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 |
|
Ali Chadorbaf
Starting Member
44 Posts |
 Posted - 2007-10-16 : 18:15:42
|
| Hi,I'd like to create a temporary table (# or ## table) and have it available in DataFlow to work with it. I see I can create it using "Execute SQL Task" component in ControlFlow; but it's not available in DataFlow. It seems it should be created by a DataFlow component to be seen in the same DataFlow. Any Idea on this? |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-10-16 : 20:12:39
|
| Ali,Why do you need to create a temp table on a SSIS package? Temporary tables are only available while the connection is open, when the connection closes, the table is automatically dropped from the tempdb. |
 |
|
|
rav3n0u5
Yak Posting Veteran
88 Posts |
Posted - 2007-10-20 : 14:59:59
|
| If you intend to use this table often, it might actually make sense to create a physical table with proper indexes. Part of your package might include wiping the records from the table after you are done. |
|
|
|
|
|
|
Create/Access temporary tables in SSIS?