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