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 : 22:49:04
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-24 : 13:25:07
|
| i think what you need is to pass values through global variables to the ssis and add another sql task at the end to execute the procedure to do the necessary processing |
 |
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2009-07-25 : 22:21:03
|
| Thanks Visakh... I am able to pass tablename and filename using variable and it works, the problem I have is when the I get another file with new fields and more fields the mapping is not dynamic even though the first row in the file has the same column names and the table has same column names. The issues is with the mapping otherwise passing flat file as variable and staging table as variable works... Any suggestion.. I am new to SSIS so I am sure there is a way. THanks! |
|
|
|
|
|
|
SSIS using Parameter