Hi, I want to pass in a variable from my T-SQL and use it as a parameter in my Dynamic task properties task. is this possible? I am trying to pass in my parameter this way xp_cmdShell 'dtsrun /works /works/works/NworksTEST_global /A cValue:8=E'
I want to use the ComposValue in the Dynamic Properties Task - something like - Select * from [table] where c = DTSGlobalVariables("ComposValue").Value
Is this possible? Is there another approach I need to be looking at instead?Thanks!
asked Jul 07, 2011 at 05:50 AM in Default
An alternative approach would be to have that value put in a specific place in the database (ie a table) just before you call
answered Jul 07, 2011 at 08:09 AM
OK. According to my SQL 2000 DTS book, you need to use the format:
The quotes are required. See also [MSDN on DTSRun]. There are a couple of caveats in that link.
If you want to build a sample command line to see what it should look like, try running