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)
 parameter from execute sql task

Author  Topic 

cbeganesh
Posting Yak Master

105 Posts

Posted - 2004-02-09 : 14:27:59
Im trying to pass a parameter from a sql execute task on DTS.
In the sql task if i give EXEC procedure_name ?
and hit the parameters Tab, I get access vioaltion error
I have declared a global variable and passing the value from outside
the DTS package using /A qualifier
Help !!!
   

- Advertisement -