I am using Visual Studio to create a SSIS package to convert a SQL file into a Pipe Delimited text file without the header row.
I have tried several times to skip the header rows. I set the number to 1 on the general screen for Header Rows to Skip and enabled the Column Name in the first data row.
I still get the row headers.
What am I doing wrong?