Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
machiaveli
Starting Member
2 Posts |
 Posted - 2005-01-30 : 16:15:45
|
| I was wondering how i could use dts to import accessfiles and then archive them to another folder. I've 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:\archiveIf someone can help me with this, i would be very greatful. I'm struggling with this a couple of months now. |
|
|
|
|
|
import and archive access files