Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-25 : 09:00:45
jagath writes "1. How can I pass an external parameter to a DTS task. For eg. I want to pass a user id to a Data Driven Query Task to Update a column in the destination table.


2. How can I execute a DTS package from C#. I have already created the package and I want to run it from C#. NET"

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2002-02-26 : 13:23:39
Haven't used DTS in a while but i believe there is Global Variable task where you can assign variables and then pass values into them from anywhere via VBScript.

Go to Top of Page

JamesT
Yak Posting Veteran

97 Posts

Posted - 2002-02-26 : 13:30:05
Books on-line has a nice bit on global variable and populating them at DTS runtime. The topic is: Using Global Variables with DTS Packages

Perhaps this may help?

Go to Top of Page
   

- Advertisement -