Post reply

imports from variety of files

  • February 8, 2005 at 7:53 am

    #163536

    I have a situation where every night files are received from client sites via ftp. These files are in a variety of formats (.csv, .mdb, .tsv, .txt) and many have a .log extension, which I believe is just for uniform naming convention purposes.

    I would like to develop an import package to consolidate all these files into one database, so I can perform other processing on them.

    What would you recommend as a best means to accomplish this?

    I was considering a scheduled job using a series of conditional OpenDataSource statements. Is this the best approach?

    Thanks.

  • February 8, 2005 at 11:26 am

    #541201

    I'd use DTS for the import.  It has connection objects for all formats you listed.  It can be scheduled as a job.  If the filenames are consistent, you could do all the imports in a single package.

    Greg

     

    Greg

  • February 8, 2005 at 11:40 am

    #541205

    Thanks Greg.

    Unfortunately, that is part of the problem. I am trying to find a means to standardize several elements. File naming conventions and layouts are...flexible. One thing going for me is that at least files of the same type (xls) have similar fields included.

    Peter

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

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