June 11, 2004 at 10:38 am
Inside a SQL2K DTS package, there is a global variable called "Status_Ind", which is a bit. Can I write some kind of a TSQL statement that will allow me to set the value of this global variable? Does anyone know the syntax?
Thanks.
June 11, 2004 at 11:05 am
2 ways I know of (there may be more).....
Use a Dynamic Properties task to set the value (you can use a query, ini file etc)
or
Use a stored proc and pass parameters as the output from the proc to the gv
August 23, 2004 at 11:24 am
I had been using the following style to run the DTS in a job:
exec master..xp_cmdshell 'dtsrun /S"ServerName" /E /N "DTS Name"'
and that's been working fine. Could you give a sample line on how the parameters could be passed to the DTS in T-SQL? I'd prefer that it not have to go to an outside source (INI file, record in a table, etc) to get the information it needs. My goal is to not have those kinds of dependencies.
TIA
Andre
August 23, 2004 at 2:06 pm
Look at DTSRUN in Books Online, specifically look at the /A switch, it allows you to pass global variables in.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply