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 |
|
shifis
Posting Yak Master
157 Posts |
 Posted - 2007-01-09 : 13:46:09
|
| HiI used the Import/Export tool to create a Job that first connect to a sql server 2000 database execute a query and send the result of the query to a Oracle 9i table.The package that was generate works just fine but when I run the job ( I scheduled Mondays at 2:00am) it sent the next error:Executed as user: SQL_SMART\Administrator. ...Run OnStart: Delete from Table "LAWSON"."TB_PLANTILLAS" Step DTSRun OnError: Delete from Table "LAWSON"."TB_PLANTILLAS" Step, Error = -2147221005 (800401F3) Error string: Invalid class string Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147221005 (800401F3); Provider Error: 0 (0) Error string: Invalid class string Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147221005 (800401F3); Provider Error: 0 (0) Error string: Invalid class string Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 5300 DTSRun OnFinish: Delete from Table "LAWSON"."TB_PLANTILLAS" Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.The job failed. The Job was invoked by User sa. The last step to run was step 1 (pckHeadCount).What I need to change? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-09 : 13:56:38
|
| Log into the database server directly using the account that the SQL Server service uses. Then try running the DTS package. Does it error there as well?This mimicks what a job does. You always need to test directly on the database server using the SQL Server service account to ensure of permissions, network paths, etc... from the database server's and service account's perspective.Tara Kizer |
 |
|
|
|
|
|
Job fail but packages don't