Post reply

Appending data to csv files

  • September 10, 2003 at 5:57 pm

    #358248

    I have several jobs that get run through DTS, to an text file in csv format. I would like to simply be able to append the data to end of the csv file whenever it gets run.

    I have another case where it would be better if I could generate a unique output file name. What is the best way to append the a date/timestamp to the end of the file.

    thanks

  • September 15, 2003 at 5:44 pm

    #474276

    Using the text file connection, DTS will re-create the file each time the datapump runs. To append to an existing file you would need to output to a second file then use the FileSystemObject in VBScript to merge the two, or use the DOS copy command.

    For adding the date to the fielname check out http://www.sqldts.com/default.aspx?200

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

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

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