May 18, 2010 at 11:59 am
Is this right? When doing a simple load table from OLEDB to flat file csv, you cannot include column headers in csv results? This is sending me crazy. I could always do something before hand to ensure the flat file is blank apart from the column headers, but what if the table structure changes? I need to be able to overwrite destination but include column headers from source table. Please help!
May 18, 2010 at 12:45 pm
assuming you are doing this with an SSIS based on where the thread is posted. Then no you can not set it up to pick up header columns when the table structure changes. beyond anything else if you were to change the table structure the meta data for the SSIS would cause the SSIS to fail.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
May 18, 2010 at 1:30 pm
That's right .. it will result in a meta data error... If you want a dynamic approach you need to use Script component
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply