|
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!
(comments are locked)
|
|
An alternative approach would be to have that value put in a specific place in the database (ie a table) just before you call
(comments are locked)
|
|
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
(comments are locked)
|
