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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-09-11 : 07:37:39
|
| Hi u created a DTS package and scheduled it to run but the package does not run, some one mentioned DTC to me but i do not know what a DTC is can any one help or explain ? thanks... the log file gives me no usefull info.. |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-11 : 08:34:09
|
| Is SQL Agent service running?Kristen |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-09-13 : 07:34:34
|
| I assume so as that DBA is looking after it, one problem might be that fact that i had links to file names and i was not using the full netowrk name so i fixed that and it still did nto work. i keep you posted. |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-09-18 : 07:32:28
|
| Am still not having any luck with this, one thing that might be causing this is that my files are on a different server than the SQL server but should this make any differences ? My source file .txt are on server 1 while the SQL is on server 2 i've all the network path names in correct not using any mapped names SQL Agent is running etc..Here is the error message am getting."Help context: 5003051 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -534709256 (E020FBF8) Error string: The Microsoft Jet database engine cannot open the file '\\IRLDUBsan03\consumables\Consumables_Orders_Cost_Reports\DataBase\Consumables_DataBase\Consumables_Reporting.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Error ... Process Exit Code 8. The step failed."The file is not open by another user as you normally get the .ldb file with the lock on it if the file was open.. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-18 : 07:53:30
|
quote:
...or you need permission to view its data
You must make sure that the account for which the job is running under have apprioriate rights to the file in mind. Also make sure that SQL Server Agent account has appriopriate rights the the same file.The Job schedule is working but the job fails, right?Peter LarssonHelsingborg, Sweden |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-09-18 : 08:16:53
|
| Yes the schedule runs at the time given but the job fails the DTS will run manually also. i will check that all them permissions are correct..thanks |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-18 : 08:20:25
|
| I was just wandering, because the topic title is about the schedule...Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Schedule not running.