SSIS: Insert/Update

Question

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

Answer 1

Just one solution SSIS update insert

better update syntax

If there are more records it will be slow.

Answer 2

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