CODEWITHSUNDEEP
ssisetlinsert-update
Tjekkles
Tjekkles

Reputation: 5612

SSIS: Insert/Update

I am wondering if there is a specific Insert or Update option in SSIS.

Will I have to do some coding if I want to let the program check if it is an update or insert? Or can there be an option enabled so it will check itself if the PK exists then update and otherwise insert?

Kind regards

Upvotes: 3

Views: 3720

Answers (2)

Justin
Justin

Reputation: 9724

Just one solution SSIS update insert

better update syntax

If there are more records it will be slow.

Upvotes: 3

devarc
devarc

Reputation: 1157

I don't know if I uderstand your problem properly. But I think SQL Server MERGE would be very useful here. And it's super-efficent.

More info here:

http://technet.microsoft.com/en-us/library/bb510625.aspx

Upvotes: 1

Related Questions