November 19, 2005 at 3:04 pm
Hello everyone,
I am trying to get a global variable from a package that called in a SP but don't know how to do.
What I have is a package that has a SP in it. This SP outputs a value that becomes a global variable in this DTS package.
I want to call the above DTS package through dtsrun utility and get the output from the above SP that is a global variable from this DTS package.
I can use the syntax [/A global_variable_name:typeid=value] to FEED a global variable for a DTS package but don't know how to GET a global variable from a DTS package.
Does anyone know how to do this? If you know, please help me to do this.
Thank you very much for your help!
November 21, 2005 at 2:39 am
Couldn't you just INSERT a value into a table on the server and then pull the results back from there?
November 21, 2005 at 3:39 am
Did you try and run the SP seperately?
November 21, 2005 at 8:16 am
Check out these two articles. They helped me a lot. As a result, what you are trying to do, I am now doing all the time.
http://www.sqldts.com/default.aspx?205
http://www.databasejournal.com/features/mssql/article.php/1459181
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply