I am new to SSIS and I have created a package that generally successfully takes a Flat File Source, runs it through a Derived Column transformation and then pushes the data into a SQL Server Database.
I have a Derived Column Error Output set up, but it is not working. If the data has an error the entire package fails, not just the specific row. I have tested the package to load successfully and then manually gone into the flat file and
changed the data to purposely create an error in one row. Having cleared the load table I rerun the package and it fails entirely rather than redirecting the one bad row.
In the Derived Column Transformation Editor I set the Error and Truncation values to Redirect Row for all the columns.
In SQL Destination Editor for the bad rows I am only mapping the ErrorCode abnd ErrorColumn values to the destination table fields of the same name. Could this be the problem? Should I map all the fields? I would like to map all the source
(derived) fields into a single text field in the destination table if possible.
The Advanced settings have only the Table Lock and Check constraints boxes checked. Timeout is 30.
I am not really sure how to set the Advanced Editor properties. I have left them at the default values. Any suggestions here?
View Complete Post