July 20, 2015 at 12:44 am
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
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 20, 2015 at 1:10 am
Actually this is for data migration from one DB to another DB
July 20, 2015 at 1:42 am
maddukuru.rambabu (7/20/2015)
Actually this is for data migration from one DB to another DB
Splendid.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 22, 2015 at 2:45 am
Do full table load otherwise use an incremental load. You can use Merge in SQL to implement incremental load.
____________________________________________________________
APViewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply