Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2009-07-21 : 20:40:33
|
| 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 |
|
|
|
|
|
SSIS using parameters for file and table