Marcus Aurelius
asked on
4. SSIS- Using one SQL command, how can you insert and update data into a table? Are there any drawbacks using this method?
I'm wondering, when I use a single SQL command in SSIS, how do I do an "insert and update to data in a table"?
Are there any drawbacks using this method?
Are there any drawbacks using this method?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The merge statement is the best way to go if the source data is a table, which is why I asked.
So ... is this question answered?