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 |
|
QAZAFI
Yak Posting Veteran
50 Posts |
 Posted - 2008-12-11 : 16:56:49
|
| Hi AllI would like to use temporary table in my SSIS package. What I am actually looking for I need to create a Global Temporary table and then need to pull data from Excel source into this temporary table. After inserting data inside temporary table I need to compare that data to another table. But I could not manage to find a way to get it done. I tried to use the approach used in the link below but it does not work for me. http://blogs.conchango.com/jamiethomson/archive/2006/11/19/SSIS_3A00_-Using-temporary-tables.aspxI need to know do I need to drop this table explicitly in the package. How it work.Any help is much appreciated Many thanksSyed Qazafi |
|
|
QAZAFI
Yak Posting Veteran
50 Posts |
Posted - 2008-12-11 : 17:53:22
|
| I have fixed the problemthanks |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Using Temporary Table