Post reply

TEMP TABLE IN SSIS

  • July 13, 2010 at 10:43 pm

    #148070

    The problem I am facing in my Data Flow. I want to keep my temporary table as destination inside Data flow and soplanned to usean 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

  • July 14, 2010 at 12:00 am

    #1192556

    You need to enable delay validation and also create the temp table in the database during the same ssis session. You should create the temp table earlier in the process so it will be available for selection. You can create an exec sql task to create this temp table. Select the option to execute step for this exec sql task. When you exit debug mode you will be able to select the table as a destination in your flow.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 14, 2010 at 7:35 am

    #1192803

    Thanks for your reply.

    Now i am facing another problem,how will i send the data which is exist in temp table?

  • July 14, 2010 at 8:58 am

    #1192878

    Same way as you have inserted the data into Temp table... 🙂

    Select a Source and Write a select statement or select the temp table from the drop down.. you should do the same property changes like delay validation etc for this Data flow task also.. You also need to change the properties of TempDb connection Manager Set the RetainSameConnection Value to "TRUE" and make sure the table has been created from SSMS

  • July 14, 2010 at 6:09 pm

    #1193199

    srichaitya,

    see this link below. This should help you.

    http://sqlscrapbook.wordpress.com/2010/07/14/load-data-into-a-temp-table-using-ssis/

    Thanks.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply