Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTS Package
Message
 
To
14/06/2002 13:13:11
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Miscellaneous
Thread ID:
00667970
Message ID:
00668745
Views:
24
No can do... all of the services are started with an account that has access to the .mdb file and I used a UNC \\SERVER\DATA\WebNTI.mdb as the DataSource. Execution of the package works fine only from my notebook connected using the Enterprise Manager. If I run dtsrun from the server or as a job from my notebook it fails with the same message. I can run dtsrun from my notebook and it works fine there.

Message
Database in use or access denied (paraphrased) There is no one using the DB and Administrator has full access to the DB...
__________________________________
Stephen W. Boyd
NJATC I.T. Support
steveb@njatc.org

"Our perceptions are our personal realities" ...unknown
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform