Post reply

Insert records into temp table (#MyTable) like an Ole DB Destination

  • October 28, 2008 at 5:07 am

    #128219

    HI all,

    I create a TEMP table like #foo in control flow SQL task....and all is fine.

    -------------------------------------------

    CREATE TABLE #foo(bar int)

    GO

    INSERT #foo

    VALUES (1)

    -------------------------------------------

    It's possible INSERT recont from a flow and not directly from SQL...'cause I got a data flow from TXT file...that want update into my TEMP table (#foo) ... something like OLE DB destination...but into my Temp Table.

    Is possible?

    Thanks Alen, Italy

  • October 28, 2008 at 6:47 am

    #890567

    Yes, it is possible. Check following blog post how to do it.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • October 28, 2008 at 7:20 am

    #890600

    Tnks...but I know that post...

    "...My imaginary scenario is one where I want to create a temporary table using an Execute SQL Task and then consume it using an OLE DB Source component in a data-flow task. Here's what you have to do:.."

    I don't want consume it using an OLE DB Source...but I want insert data into like an OLE DB DEstination

  • October 28, 2008 at 7:24 am

    #890606

    If you checked the post carefully you will see this scenario is possible. You have make sure you use the same connection object in the Execute SQL Task and the data flow and use DelayValidation option for the OLE DB Destination component. This information is included in the post I have sent you.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • October 28, 2008 at 8:05 am

    #890640

    You could always create a static table in TempDB as well....i.e.

    create table tempdb..blah

    (

    id int not null,

    somecolumn char(10)

    )

    Then drop the table when you are finished with it. As already pointed out in an earlier post you will need to enable the DelayValidation option.

    Tommy

    Follow @sqlscribe

  • October 28, 2008 at 8:12 am

    #890648

    OK I think this best way...thanks...

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

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