Post reply

export table to text file dts package creation date problem

  • May 19, 2004 at 4:00 am

    #160938

    Hi,

     

    I have a DTS package which exports a table to a Flat File .txt

    I executed the package today (19/05/2004) but the creation date of the file is 18/05/2004

    any help appreciated

  • May 19, 2004 at 6:56 am

    #506935

    Do you use Global Variables? if not it might be worth looking at BOL

  • May 19, 2004 at 8:35 am

    #506952

    thanks for replying

    i used the wizard to create the package. I don't know what a global variable is.

    do you mean Books Online ?

  • May 19, 2004 at 11:59 am

    #507000

    Did the file already exist before the execution of the package today? If so the creation date will remain as it was originally. When it comes to changes you need to be concerned with the modification date rather than creation date.


    Shamless self promotion - read my blog http://sirsql.net

  • May 24, 2004 at 1:12 am

    #507420

    Hi

    Exactly, I import a file into a table, do some modifications then export it. So I figured when the table is exported it is considered as a new file.

    are you saying that if I export it with the same name and location, it will be considered as the same file than the one i imported ?

     

     

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

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