I was wondering how i could use dts to import accessfiles 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:
- import an accessfile which has a name like this <companyname>_<today's
date>.mdb. The importfolder is called in my case d:\import
- for updating some fields, the dts should use the company's name from the
accessfile and check that with a lookuptable to translate the name into a
int value.
- after some 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.
--
----------------------------------------------------
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.com