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 |
|
TexMurphy
Starting Member
9 Posts |
 Posted - 2006-07-06 : 10:52:37
|
| I have set up a DTS to import data from an Access database to a server which is running SQL. It works alright if I execute the DTS, but if I set it to run as a scheduled task, it tells me that the path to the access db is not valid, and that I should make sure the path name is spelled correctly and that I am connected to the server on which the file resides... so obviously it's not a spelling issue (since when I execute it, it works), but a security issue. Anyone have any ideas?Thanks a lot,Tex |
|
|
TexMurphy
Starting Member
9 Posts |
Posted - 2006-07-06 : 11:07:29
|
| Also that Access database references another one (the two access DBs are on the same drive). |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
TexMurphy
Starting Member
9 Posts |
Posted - 2006-07-06 : 11:38:53
|
| Yes, but I realised it was in the wrong section, so I posted again in the right one in the hope of more replies. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2006-07-06 : 11:40:21
|
| The user account that you use when you execute a package is not the same that runs the sql jobs (scheduled tasks), you need to check what account is running the MSSQLSERVER service on that box and check if that account has the rights to access the this file, this is a very common issue and can easily be fixed. Find out who's running the MSSQLSERVER service and log into the box with that account and try running the DTS, that will tell you where the package is failing and what to do.Here in my company we have a domain user with local admin privileges, so that account can still use other network resources. Hope this helps.---Thanks!Igor. |
|
|
|
Riti
Starting Member
1 Post |
Posted - 2006-07-07 : 13:21:30
|
| Hi, I am new in the world of SQL Server. I am having a problem as well when I am trying to schedule a DTS Package to import from a text file into SQL Server. I am getting this error " The job failed. The Job was invoked by Schedule 177 (Run Test). The last step to run was step 1 (Run Test DTS). ". I am executing this package with windows Authen... Do I need to be looged on as SA to schedule the package?Can someone please help me |
|
|
|
|
|
|
|
|
DTS permissions and schedules