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..

Hello kausmail (AT) gmail (DOT) 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