Dear All,

I am new to DTS. I came to know from site that I can use a Activex Task in DTS to dynamically change the connections/Query etc.

Can any one give me a step by step instruction on how to go about it. This will reduce my Data importing problems from the main server to the test server on a daily basis.

Please help me.

You can e-mail me on