Redirect Flat File records with blank column values in SSIS Data flow task

Chalut, Mylène - ITSLM/GCSTI 21 Reputation points

Hello guys,

I have a flat file that I need to load in SQL Server. I would like to output the records where columns have blank values to a flat file without aborting the process. I created a SSIS package (VS2015) with a Data Flow task and a conditional split to do so... but it's not working !! It does remove the records with blanks, but I am not able to output them into my flat file.

Here is what I did...



Can somebody help me resolve this please ?

Thanks in advance for your help :-)

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,231 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 25,611 Reputation points

    Hi @Chalut, Mylène - ITSLM/GCSTI

    Please make sure that the Error Output has data in your package.

    If you are using isnull expression to check the null value, it will not return error data from my test.

    Why not load the flat file data into a staging table and then use TSQL command to select the valid columns and invalid columns, and then load them to the destination.


    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments