import/archive files with dts

[DTSFreak]

Hi,

I was wondering how i could use dts to import MSaccess-files and then archive them to another folder. I've read some examples on sqldts.com but i still can't figure it out.

Basically this is what i want to do:

- import an access-file which has a name like this <companyname>_<today's date>.mdb. The importfolder is called in my case d:\import

- import tables to temporary tables for processing (maybe to the tempdb, if possible)

- update some fields, the dts should use the company's name from the access-file and check that with a lookuptable to translate the name into a int value.

- after processing, the dts should place the file to another folder. In my case it is d:\archive

If someone can help me with this, i would be very greatful.

 

[dbomrrsm]

access connection - sql server connection - SQL task - 2nd access connection

transform task between access connection and sql server connection to import file - SQL task to manipulate data in SQL server - transform data task from SQL Server to 2nd access connection

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]