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 |
|
marcusn25
Yak Posting Veteran
56 Posts |
 Posted - 2014-10-19 : 14:59:34
|
| Hello SSIS Guruz,I am fetching data from an import file and I would like to insert that data into a temp table in SSIS and then pass that data to a temp table in a stored procedure .. Is that possible please, any ideas how i would go about it .. ThanksMarcusMarcus I learn something new everyday. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-19 : 16:13:35
|
| that is only possible if the temp table is created in the same session as the one calling the stored procedure. That is, if you create the temp table in one Execute Sql task and try to use it in a subsequent task, you'll find that the temp table is not found. That's because the first task ran in one session and SQL server dropped the temp table at the end of the session. |
 |
|
|
|
|
|
Pass temp table to a Stored Procedure Temp Table