SSIS Tutorial Part 10 -How to Redirect Rows From Flat File Source in SSIS Package

In this video we will learn how to read the data from flat file source and then produce Data Conversion Errors by changing source data and Truncation Error by increasing the width of data in our flat file.

By performing that we will get below errors

 The data conversion for column "id" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".

 The data conversion for column "name" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

After understanding the Errors, we will go to solution part and Learn How to redirect Rows from flat file source and understand Fail Component, Ignore Failure and Redirect Rows options.

As Error Column is not provided in the Redirect Error Row, we will discuss what other options we have.


How to Redirect Rows From Flat File Source in SSIS Package - SQL Server Integration Services ( SSIS ) Tutorial



Check out our other related posts/videos on different SSIS Sources

No comments:

Post a Comment