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.