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
 SQL Server Development (2000)
 Parameters in DTS Tasks (DB2)

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-26 : 10:54:06
Paul writes "I want to use values held in a SQL Server 7 table in a DTS Data Pump Task which uses a DB2 ODBC connection. If this was against the SQL Server Connection I could put the values into the DTS Task using T-SQL as it would be using the same connection object.

However i'm not sure about DB2 (v2.0).

Having read about using Global Parameters - I wonder if these can be used and how I could pass these values in the DTS Task. Or is there a better way ??

Thanks"
   

- Advertisement -