HI All, I have a question regarding SSIS -- How to send list object from .NET Application to object variable created in SSIS Package. In List object there are one lack records stored..This list object needs to be passed to SSIS Package. Please reply me back with any suggestion/solutions ...Required ASAP. Waiting for your replies. Thanks, vineesh1701

Hello Vineesh, I am not sure, how that will be possible. Just a work around in my mind. 1--Change the application , Write the list records to SQL Table. 2--Create a Package in SSIS, then use Execute Process Task to run the application from SSIS package 3--Then use Data Flow task and extract the records from Sql table and use them as required. I am looking forward for some expert advice on this too.... Thanks

Thank you. If any one has any other ideas in this regard can you please help me out. Appreciate your help. Thanks, vineesh1701

It's not possible to pass objects into an SSIS package via command line arguments or package configurations. If you can architect your environment to execute the package from code, then you can use the LoadPackage API call to read the package, then assign your "list" to an SSIS variable within that package, then Execute the package. But since it's not typical to be able (or want) to create a .Net application just to run your package, you'll probably need to persist your data somewhere. Aamir's suggestion of SQL tables will work, as would a flat file, an XML file, or possibly just serializing your list contents into a (long) string that you could pass in to the package using command-line arguments or package configurations. Personally, I would use a SQL table, flat file, or XML file. Talk to me now on