I am using SqlBulkCopy within a Script Task to extract data from an Oracle server into SQL Server. Is there a way to redirect error rows with code or otherwise from the SqlBulkCopy?
I have implemented this before using a regular Copy Column task and redirecting the Destination Error into a different table of all data type varchar. So I am trying to make something similar with the script task and SqlBulkCopy.
ThanksYou are so wise...like a miniature budha covered in fur. -Anchorman
View Complete Post