Can you pass an array as a parameter into a package from the comman line?
The title pretty much says it all... I want to pass a 3 x 5 array of strings to the package from a command line. Thanks. J
November 15th, 2011 12:53pm

I would say not. I don't think the Object type variable works well interfacing OUTSIDE of the SSIS package that it is in. Maybe a better approach would be to populate a simple CSV or TXT file with the data you want, then pass in the path to that file. Have the package pick up the path in a variable and read the file into an Object type variable.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2011 3:12pm

you can pass a single parameter, then delimit the string using | pipe or ; semicolon, then from parse it. Ex: 001;A;100|002;B;200 1st split it by | and then by ;Randy Aldrich Paulo MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog
November 15th, 2011 4:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics