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.

Check out our SQL Server Integration Services ( SSIS ) Tutorial Step by Step

[krismaly]

This is an awesome video explained the functionality with crispy examples.

I enjoyed watching this video and recommend other.

Thanks for educating the community.

Thanks a bunch

[krismaly]

Revisiting.

It's a nice video and a developer should watch and learn easily

Thanks

[rohitkolekar]

Your video is helpful, Could you help me to understand how can I redirect rows if truncation or Conversation if source is Excel

[sprihasingh]

I am getting cannot access flat file error