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.
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
- How to Load Tab Delimited File To SQL Server Table in SSIS Package
- How to Load Pipe Delimited File into SQL Server Table in SSIS Package
- How to Load Multiple Comma Delimited Files to SQL Server Table in SSIS Package
- How to Load Fixed Width Text File to SQL Server Table in SSIS Package
- How to load Data From Comma Delimited text file to SQL Server Table in SSIS Package
- How to convert blank values to Null in Flat File Source in SSIS Package
- How to use Raw File Source in SSIS Package
- Fast Parse Flat File Source Property in SSIS Package
- How to use Stored Procedure with Parameters in OLE DB Source in Data Flow Task in SSIS Package
No comments:
Post a Comment