I need to create a flat file which is in the following format.
Records added to tableA(TAB)Count from Select statement Row1Col1 of Select statement(tab)Row1Col2 of Select statement Row2Col1 of Select statement(tab)Row2Col2 of Select statement Row3Col1 of Select statement(tab)Row3Col2 of Select statement . . . .
I have the select statement ready and it is getting outputted to a flat file properly. I am having issues with adding the first line where the count of records entered in tableA and count of records of select statement are to be provided.
How could I achieve this merge? I am using OLEDB sql stored in variable option to get the information.