How to delete a column in Flatfile after parsing the data

Hi all,

I am trying flatfile parsing. I have successfully parsed the flatfile by flat file schema. Now, My requirement is after parsing the data…if there are any NULL fields under any column. It should not display that column.

For example, X is a column. In the flatfile there is no value for X. So, after parsing…it should not show the column X in the output.

I tried using…Format Services…but I didn’t had any luck.

Please help with your suggestions.

Thanks in advance.

What is the target format? How is it defined?

There is no direct way to accomplish this…But once you parse the data you can create a temp document and map/append the only records that are not null…and later use this new temp document in your downstream process.