Post reply

What is the best File Connection Manager (To connect from destination task within Data Flow) to use to output result of sql statement to .CSV file?

  • September 27, 2018 at 2:28 pm

    #368826

    What is the best KIND OF
    File Connection Manager (To connect from destination task within Data Flow) to use to output result of sql statement to .CSV file?

    Also, can leading zeros from int or char(n) columns be preserved in the output  .CSV files?
    (without using any single or double quotes to encase the string like 0053. (it turns to 53)  🙁 
    )

    Likes to play Chess

  • September 27, 2018 at 4:30 pm

    #2007313

    VoldemarG - Thursday, September 27, 2018 2:28 PM

    What is the best KIND OF
    File Connection Manager (To connect from destination task within Data Flow) to use to output result of sql statement to .CSV file?

    Also, can leading zeros from int or char(n) columns be preserved in the output  .CSV files?
    (without using any single or double quotes to encase the string like 0053. (it turns to 53)  🙁 
    )

    Define what you mean by 'best', please. Also, I can only think of one File Connection Manager that can output to a CSV file, and that is the Flat File Connection. What else do you have in mind?

    int columns do not have leading zeros.

    char columns can be output as char columns and their contents should be unchanged.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply