October 28, 2002 at 11:03 am
I have a DTS package with a Connection object set up for IBM DB2. Also, in this DTS, I have an ActiveX script which changes the SourceSQLStatement of the DataPump Task which pulls data from DB2 to SQL Server. I would also like to be able to change the connection properties of the DB2 connection object in this same ActiveX script. Can anyone provide direction in setting up connection properties of a connection within an existing DTS package?
October 28, 2002 at 11:26 pm
Search Books OnLine, set the active subset to Data Transformation Services, search for Object Model, and look at the article entitled Configuring Properties for DTS Transactions. From there you can hyperlink to Package Object, then click on Connections. This will get you to the Connections Collection. From there you can click on the hyperlink at the bottom of the page to get to the Connection Object. This will give you a list of the properties and methods. From there it is pretty much straightforward activex scripting...
hth,
Michael
Michael Weiss
Michael Weiss
October 29, 2002 at 6:15 am
Take a look in the FAQ or Download section of http://www.sqldts.com for some possible ways of doing this
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply