February 17, 2011 at 12:02 pm
Hi folks,
I am really bad in writing the dtexec syntax .
I have stored procedure with 3 parameters and I am calling that in SSIS using dataflow task and i mapped my parameters to variables and everything is fine. I had given some default values to my variables and my package is running fine in my bids.
Now i wanna run my package using cmd shell or management studio using dtexec and i wanna set the dataflow variables in this dtexec. I having trouble in setting the variables. When i try to execute the below it's just executing with default values not taking the values which i'm trying to pass.
Help me with the syntax since i wanna pass these values to my variables.
exec xp_cmdshell 'dtexec /f " C:\Tasks\Integration Services Project1\Package1.dtsx "
/set\Package\DataFlowTask.Variables[User::MyVariable].Properties[Value];20
/set\Package\DataFlowTask.Variables[User::MyVariable].Properties[Value];30
/set\Package\DataFlowTask.Variables[User::MyVariable].Properties[Value];"F"
suggest me if i'm missing anything. (my user defined variable are a, n , c )
Thanks.
February 17, 2011 at 12:17 pm
Have you tried replacing MyVariable with the variable names?
Also, take a look at DTExecUI. It can be a real savior sometimes for generating the command string for you.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 17, 2011 at 1:22 pm
Thanks for your reply.
Yes i tried sir, but it didn't worked.
Even i tried using dtexecUI but i don't where i should pass my parameters ?? if i use command line option what should be my syntax to pass the variables ???
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply