Hi,

I've created a DTS which pulls off an XML doc from a url, stores some of
the values into dts global variables and then runs a query based upon
these values.

I now need to run this DTS from a stored procedure, but I need to pass a
value to the DTS to be used as a DTS global variable.

Is this possible?? and if so can someone please tell me how to do it.

At present I use DTSRUN in a stored proc, but I don't think you can pass
a parameter using this command

M3ckon

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can using v2000 os DTS. Look at the /A switch

--
--

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


"m3ckon" <anonymous (AT) devdex (DOT) com> wrote