sql server dts: Hi,

I am a newbie. I am trying to configure Dynamic Properties task in a DTS
package. The DTS package is supposed to move data in 6 tables from one of the
Production servers to the Test Server. The Production Servers can either be
PROD1 or PROD2 that will be passed to the package during runtime.

I have created a Global variable with the name "ProdSourceServer" in the
package properties that is of Type "String" and Value of "PROD1". In the
Dynamic Properties task I can see the Destination Property as "Value", Source
Type is "Global Variable" and Source Value is "ProdSourceServer". Still it
doesn't work. I have created a package earlier with Dynamic Properties Task
and it had "DataSource" as the Destination Property. I don't know what am I
doing wrong this time. Any help will be greatly appreciated. Thanks in

Hello sharman,


Using the DP task you would navigate to the property on the connection you
want to set. You then choose GV as the type and your specific Global variable.

You could do this through an Active Script Task but you could also do this
programmatically through the object model.


--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]