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.

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.

Thanks for the reply.. it is possible to read a xml variable in SSIS? Regards, Eshwar.

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.

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