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
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • 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