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

Question

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 :-)

Answer 1

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.

Regards，

Zoe Hui

---

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