The global temp table gets created and once it gets built I can do a select in Aqua sql editor and see the records. Next in a Data flow task I am trying to select from this global table and then need to push it to a permenant table. Hello Brady, I have created a global temp table in the ssis pkg and have loaded data into it in the execute sql module. Monday, Septem12:15:52 PM - Kamala Raghunathan Alternate solution can be using a permanent table in temp db instead of a temp table but I don't have permissions to use a permanent table, I must use only temp tables. Probably whats happening is as the session ends my global temp is dropped. But I cannot access the temperory table from my SSMS, like if I query: Select C1 From #Temptable, the table does not exist. My SSIS package is loading data into a global temperory table at Temp DB, the package runs successfully. Thursday, Febru3:09:55 PM - Cordell Prediger
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |