Hi,
How to pass variables into a dts and run the dts from a stored procedure ?
I want to pass 2 variables to a DTS,
one is a CodeID and the other is a filePath
And of course, I want to change the current filepath with the new that I
send.

Thanks for your precious help

Stan

If you are using 2000 then a combination of Global Variables and the /A
switch to DTSRUN will sort you out.
If you want to use the sp_OA* family of stored procs then you get into the
object model and set them through that

Execute a package from T-SQL
(http://www.sqldts.com/default.aspx?210)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Stan Sainte-Rose" <stan (AT) cyber972 (DOT) com> wrote