Post reply

Deleting the contents of a text file before import

  • February 26, 2013 at 3:52 am

    #274550

    Hi All,

    Is there way to in SSIS to delete the contents of a text file before importing data into it? Just how you can truncate a table before adding data to it. Is it possible in SSIS?

    Thanks

  • February 26, 2013 at 4:00 am

    #1591108

    YarHad (2/26/2013)

    Hi All,

    Is there way to in SSIS to delete the contents of a text file before importing data into it? Just how you can truncate a table before adding data to it. Is it possible in SSIS?

    Thanks

    Sure. Just make sure that the 'Overwrite data in the file' box is checked in the flat file destination editor.

    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

  • February 26, 2013 at 4:16 am

    #1591114

    Phil, Thanks a billion!

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

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