Hi, I'm trying to dynamically build a csv file, at start I delete the file. Then Create using a Data Flow task with a Ole DB Source writing to Flat File Destination. the source being: Select '' as 'Error Task' and it writes the file but when the Csv files is viewed in notepad it adds extra commas. Should have been: Error Task but outputs: Error Task , , , or how can i create the file using the script task Please Assist, Regards
FYI, here's a blog post with a sample for handling this type of problem in a script component: http://agilebi.com/cs/blogs/jwelch/...at-files-with-varying-numbers-of-columns.aspx and using derived columns: http://agilebi.com/cs/blogs/jwelch/archive/2007/05/16/handling-varying-columns-part-2.aspx
Thank You for the assist, at the moment I don't have that problem with comma's inside the string value. Created a template file and then have a File Copy task which just copies it to the required destination.
Created a template file and then have a File Copy task which just copies it to the required destination.