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 using stored procedure

Author  Topic 

ineedhelp
Starting Member

11 Posts

Posted - 2005-02-15 : 22:38:53
I have to create a DTS package which runs on a stored procedure that takes parameters. I was able to do it using Execute SQL Task and global variables. But strangely, it works for varchar type of parameters only and not for interger types. The same thing happened with query based DTS package also.

Thanks for your help.
   

- Advertisement -