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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-11-24 : 07:33:57
|
| Hi can i work with a temp table in a DTS ?, i'd like to create a temp table and then move data from it into another table is this possible ? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-24 : 07:41:04
|
| It surely can be created in DTS. But depending on your requirement and data load, you may want to choose between Temp table or permanent work (staging) table. Also, if you stick to Temp table idea, make sure to drop it at the end of package.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-11-24 : 07:51:57
|
| Ok i've created the temp table but i would like to pick data from it to move to another table so i want to use the temp table as the source, but when i select the transformation tab am getting an error |
|
|
|
|
|
|
Temp Table in DTS