Post reply

help needed for Data transformation using ssis

  • June 17, 2010 at 10:55 am

    #139469

    Hello all,

    I am a newbie to SSIS,

    I have a situation where I need to pull data from serverA which is 6million into serverB .

    I can pull all data and insert into a table.

    But, I need to pull the data based on some date condition.

    because I require only few rows.

    Can anyone explain me that.

    Thanks in advance

  • June 17, 2010 at 11:05 am

    #1181725

    Use a query.

    INSERT INTO TABLE_Z

    SELECT col1, col2, col_x

    WHERE col_y BETWEEN DATEDIFF(dd,GETDATE(),-7) AND GETDATE()

    Converting oxygen into carbon dioxide, since 1955.

  • June 17, 2010 at 12:07 pm

    #1181770

    where do you want me to use this query?

    In oledb destination?

  • June 17, 2010 at 12:17 pm

    #1181777

    The query goes into the source object. Instead of selecting a table for the source you select SQL Statement and write the select statement you want to use. Then out the results of the source object to the destination object for the insert.

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

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