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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-20 : 06:54:02
|
| frank writes "We have an access file is password protected, i.e. the whole file is protected by a password, not the PASSWORD for DB user of the Access File.We have a DTS package to query data from Access file and dumpt into SQL server. Since the package is supposed to run once a day, I am wondering is there any way to automate the whole thing, especcially by-pass the Access Password issue. When the file is locked by password, the DTS failed.ThankFrank Jiang" |
|
|
|
|
|
DTS to pass Access Password check