tranfer file

  • Hi,

    I have DTS package which transfer the Text file to excel but it is not overwirting it. appends the data instead. How can i make to overwirte the data!!

    Thanks

  • Easiest method is to delete and re-create the file.

     

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

  • If you are using vbscript, you can use the following

    object.Copy destination[, overwrite]

    the overwrite is a boolean value - True overwrites the file.

    File.copy <filename>, TRUE

  • how about,

    coping the file on the name like filename+date!! before overwrite it!!

    how can i do that!!

    Thanks

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

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