Post reply

Load data from In memory(Table Variable) table in SSIS

  • January 15, 2016 at 4:53 am

    #310810

    Hi All,

    I am using first time In memory table concept in SSIS package.

    my requirement is as below

    1-I am loading data from source to target.

    my source is flat file.

    I want to load the flat file data into in memory table(table variable @test-2 table) and then load data from memory table to target sql table.

    Kindly help me to understand, can we used table variable in OLED Destination .

  • January 15, 2016 at 6:18 am

    #1852228

    Are you referring to this type of table variable?

    The older type of table variable is not in-memory. Nor is it good for holding large quantities of data.

  • January 15, 2016 at 6:39 am

    #1852232

    Yes, and furthermore, a table variable only lives for the duration of the batch in which it is created, so you may find it difficult, if not impossible, to use in an ETL. Try using a temp table (#table) instead (beware also: this only accessible to, and lives for the duration of, the the connection in which it was created), a global temp table (##table) or (my preference) a staging table instead.

    John

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

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