Hi,

I have a DTS package that has 12 data transform tasks. All Tasks use
same query except that each tasks gets data for different months.

I would like to convert this into one step and add active X script or
dynamic property to loop through the same task 12 times.

Can someone please help me in how to achieve this. I am new to DTS
designing.

Thanks,
VS

Hello vinay.singhania (AT) gmail (DOT) com,


Here are some articles which are really going to help

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)


What you want to achieve is certainly attainable. Have a go and come back
to us if you have any issues or further questions

Allan



Allan