Hey Guys,
I need suggestion in one issue I have...I need to run a SSIS Pakage in my PROCEDURE that will stage file in a table... and then PROC will do further processing. The filename and table name will be stored in variables in the PROC. How can we use the those variables to be used as inputs for the SSIS Package that will stage the file in the table. Files will be comma delimited or pipe delimited. I cannot use bulk insert as the data will have " around fields that has comma or pipe character embedded.
Thanks