-
Import data from MS Access: URGENT issue please!
We have a production Access database and SQL Server database. When I created a DTS package to import data from Access and run manually, it works fine. But when I schedule, it doesn't work, saying some one already opened the file or no permission error.
WE CAN'T get permissions for the Access file to the account that is assigned to SQL Server agent. It's internal policy of the company,because that account is used on all the sql servers to run the agent. Is there a work-around to import data from access. We do have a service account which has access to the Acess db.
Thanks,
-
Install SQL Client on another machine.
Use Windows scheduler to schedule the DTS package. use the account which has access to the access database
-
Excellent idea, that worked. Thanks!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|