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 - 2004-09-22 : 08:56:35
|
| Cliona writes "AfternoonWhen scheduling DTS Packages on SLQ7 Service Pack2packages that run sucessfully are failing.The package I am trying to run has a data source - Microsoft OLE DB Provider for SQL Server.Which is referenced MS Artice - 811906 - http://support.microsoft.com/default.aspx?scid=kb;en-us;811906&Product=sqlThe error is also referenced in this article:Error: -2147217887 (80040E21); Provider Error: 0 (0) Error string: Errors occurred Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.And as it suggests if I run the package from my laptop which has MDAC 2.7 installed this runs but if use schedule it fails - our main server has only MDAC 2.2 installedMethod 1 suggested is not an option - as we have a cluster and this is not supported over level 2.5 of MDAC. I have tried Method 2 but this does not work so I have a DTS package which I can not schedule.My other theory was permissions but I have tried all different permissions levels and still no joy.Does you have any suggestions which maybe of help to me that do not involve upgrading as this is not an current option for our LIVE enviroment.Main dB Server is running Windows NT 4 Enterprise Edition with Service Pack 4 & SQL 7 with SErvice Pack 2My Lapop is running - Windows XP Service Pk1 and same version of SQLRegardsCliona" |
|
|
|
|
|
DTS Package that is scheduled is failing