Data loading Problem

Question

Data loading Problem

vijay.sap1255

Mr or Mrs. 500

Points: 592
More actions
February 21, 2014 at 1:48 am

#282602

Hi Experts,
Iam facing a problem while executing the package in SSIS.
am testing with sample data taking source and target tables from sql server. I have connected the source and target and when i executed it first time it is loading the records into the target and when am executing the same package again the records are loading again instead of overwritting. for example
source table
eno,ename
1,a
2,b
3,c
when executing first time
target table looks like
eno,ename
1,a
2,b
3,c
This is fine. When i execute the same again, the target table looks like the below
eno,ename
1,a
2,b
3,c
1,a
2,b
3,c
How can i manage this to get records only once. Is there any option like "Delete target before loading" or any of the transform will help me??//.
Please guide me in this problem.
Thank you in advance,
Warm Regards,
VijayVanamala

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

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

vijay.sap1255 Mr or Mrs. 500 Points: 592 More actions · Answer 1

I guys, I have achieved this using Slow changing dimension fixed attribute. If there is any other solution to achieve this please post the solution.

Thanks & Regards

VijayVanamala

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 2

Vijay

The trouble with the SCD is that it processes one row at a time. If you are bringing in a lot of data, you might consider loading all the data into a staging table, then using a join query or a MERGE statement to load or update as required.

John

vijay.sap1255 Mr or Mrs. 500 Points: 592 More actions · Answer 3

Yes John.. That is the good Idea.

Thanks for your Reply.

Best Regards,

VijayVanamala.