Post reply

Add filename of the imported files in DTS

  • April 22, 2010 at 9:42 am

    #73498

    Hi

    I have DTS which import text files into database .All text files are are csv format. However name of each csv is time stamp. for example

    22042010235959 (date and time)

    21042010235959

    20042010235959

    Since I have to deal with lots of imports If I could also add filename which has been imported to my database field would be very

    advantageous as I would easily be able to see what was the last file which was imported .

    Any suggestion of how to achieve this would be very useful.

    Thanks for your help

    James

  • April 22, 2010 at 1:17 pm

    #1156393

    I may be missing the point but I assume you already determined the file name for import sinc you have that value can you not introduce that file into the file stream?

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

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

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