September 23, 2008 at 10:22 pm
In my SSIS package, I am creating a temporary table in my control flow using an 'Execute SQL task'. Then inside Data FLow, I want to load this temp table with some data and then finally coming back to control flow I want to update my target table from this temporary table data through an Sql task.
The problem I am facing in my Data Flow. I want to keep my temporary table as destination inside Data flow and so planned to use an OLE DB destination task to load data into this temporary table. But while doing so, I could not select this temporary table from my list of tables available.
Actually this temporary table is created under the 'tempdb' of system database not inside my defined database. So it is not coming up in my drop down list in Destination task.
I also tried the SQL command option inside 'OLE DB Destination'. But while writing the Insert Query it is not allowing me to load the data from the input columns. By the way, this OLE DB destination is fed from a Lookup task.Can anyone suggest how can I implement this? Am I missing anything? Any urget help will be really useful.
September 24, 2008 at 6:17 am
Why not simply create a permanent table, do whatever you want to do, and drop the table when you are done?
Temporary tables are unique to the session, and are dropped once the session is dropped. Its also not a good idea to use temporary tables within SSIS.
Just a thought
~PD
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply