Post reply

Import Dbase data

  • February 12, 2003 at 4:23 pm

    #80304

    Hi,

    I got one old aplication generate one DBASE file per day with differnt file name.

    I want to create one SQL Server table to import these DBASE data and run it automatically each day after DBASE data file created.

    Anyone knows which is the best practice to do this task? The data source file name is changing each day and unique.

    Thanks!

    Jie Ma


    Jie Ma

  • February 12, 2003 at 6:45 pm

    #448822

    Its a hack, but you can just build your import using filename.dbf, then as part of the package (or before it runs) you just rename the file from whatever.dbf to filename.dbf.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • February 13, 2003 at 7:32 am

    #448856

    Thanks Andy!

    I tried it. I built a package to import the first 20030101.dbf and created table in SQL Server, but I could not figured out the way to rename the target file 20030102.dbf and so on. Does Active Script Task work that?

    Thanks!

    Jie Ma


    Jie Ma

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

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