sql server dts: Import Access db to SQL server -- sql server dts

Import Access db to SQL server

kausmail NO[at]SPAM gmail.com
5/25/2006 12:19:03 PM

sql server dts:

I want to import access database to SQL server daily. Every day the
source i.e. access database filename (.mdb filename) is different. How
to design a DTS package which will dynamically find the .mdb file and
import it into SQL?
Thanks in advance..

Re: Import Access db to SQL server

Allan Mitchell
5/25/2006 12:51:22 PM

Hello kausmail@gmail.com,

How will you know where to find the DB?
Will it be the only one there?

We can do this a number of ways.

Have a look and see if this article helps

Find an Access Database (from anywhere on the file system)
(http://www.sqldts.com/default.aspx?248)

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]