Passing values from .net screen to ssis package
Hi Team, I have a question on reading the .net screen parameter values. There is a .net screen where user selects a set parameter values and clicks on execute it should execute a ETL package. How to pass the select parameter values to the ssis packages? Regards, Eshwar.
May 30th, 2012 6:04am
It depends on how you start the SSIS package. If you use the DTEXEC utility (http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx) you can use the /SET switch to assign a variable (or other property) a value.MCTS, MCITP - Please mark posts as answered where appropriate.
May 30th, 2012 8:04am
Thanks for the reply.. it is possible to read a xml variable in SSIS? Regards, Eshwar.
May 30th, 2012 8:20am
There is no such thing as a XML variable in SSIS. You have a string variable, so you could store the XML just as text.MCTS, MCITP - Please mark posts as answered where appropriate.
May 30th, 2012 8:28am
If you are executing from a .net program then I would use the managed assembly to pass the parameters and execute the package rather than shelling to a command line utility. Look here for an example http://msdn.microsoft.com/en-us/library/ms136090.aspx Chuck Pedretti | Magenic North Region | magenic.com
May 30th, 2012 8:33am