SQL Server Performance

Create Csv File from DF adds additional commas

Discussion in 'SQL Server 2005 Integration Services' started by Ismailc, Mar 30, 2009.

  1. Ismailc New Member

    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
  2. satya Moderator

  3. Ismailc New Member

    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.
  4. Ismailc New Member

    Created a template file and then have a File Copy task which just copies it to the required destination.
  5. satya Moderator

    Then, are you getting any error or not getting desired output>

Share This Page