SSIS Skip Blank Rows in Flat File Source
- Joel Lipman
- SQL Server Integration Services
- Hits: 26472
This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud:
Error: The conditional operation failed. Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "MyDerivedColumns" (4228)" failed because error code 0xC0049063 occurred, and the error row disposition on "output column "DC_MyDate" (7349)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
- Error: The conditional operation failed.
- Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component
- "MyDerivedColumns" (4228)" failed because error code 0xC0049063 occurred, and the error
- row disposition on "output column "DC_MyDate" (7349)" specifies failure on error. An
- error occurred on the specified object of the specified component. There may be error
- messages posted before this with more information about the failure.
Why?
So the solution must be obvious to you by now. At least that's what Microsoft people think to themselves every time they see the error they programmed in.
Apparently this problem also happens when you have a Data File of varying column numbers. My solution below will also fix this.
How?