Post reply

Doubt regarding Transfer SQL server Object Task

  • July 20, 2015 at 12:44 am

    #398765

    Hi Folks,

    I am using transfer SQL Server object task. By using this task we can perform below tasks.

    1) copying the schema

    2) copying the data

    3) truncate data from table and re insert data into same table

    4) Appending the data to existing data in the table.

    When I am using ExistingData property As Append the data is getting as duplicated.

    How to avoid duplicate data into table.

    Please help me

    Thanks

    Rambabu

  • July 20, 2015 at 12:57 am

    #1813582

    maddukuru.rambabu (7/20/2015)

    Hi Folks,

    I am using transfer SQL Server object task. By using this task we can perform below tasks.

    1) copying the schema

    2) copying the data

    3) truncate data from table and re insert data into same table

    4) Appending the data to existing data in the table.

    When I am using ExistingData property As Append the data is getting as duplicated.

    How to avoid duplicate data into table.

    Please help me

    Thanks

    Rambabu

    Either select option (3) or do a proper incremental load of your data using a DataFlow rather than using Transfer Objects.

  • July 20, 2015 at 1:10 am

    #1813584

    Actually this is for data migration from one DB to another DB

  • July 20, 2015 at 1:42 am

    #1813587

    maddukuru.rambabu (7/20/2015)

    Actually this is for data migration from one DB to another DB

    Splendid.

  • July 22, 2015 at 2:45 am

    #1814025

    Do full table load otherwise use an incremental load. You can use Merge in SQL to implement incremental load.

    ____________________________________________________________

    AP

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

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