July 7, 2003 at 3:28 am
Hi all
One of my dev guys is busy with execution of DTS packages from an asp page. THe packages copy a table across and if it finds the table in the destination the old table is renamed and the copied table keeps its name as the current table.
One package works well but the others which were saved from the working package don't. They were saved and then he added the rename tasks etc. The table is copied across but its empty.
I've searched most of the sql sites I'm aware of as well as MS but haven't found an answer. Here is the error msg.
EXEC master.dbo.xp_cmdshell 'DTSRUN /S ipsserver03 /U sa /P password /N FETCH_HMJ_RAS'
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: Create Table [iRSDevData].[dbo].[HMJ_RAS] Step
DTSRun OnFinish: Create Table [iRSDevData].[dbo].[HMJ_RAS] Step
DTSRun OnStart: Copy Data from HMJ_RAS to [iRSDevData].[dbo].[HMJ_RAS] Step
DTSRun OnError: Copy Data from HMJ_RAS to [iRSDevData].[dbo].[HMJ_RAS] 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: 4700
DTSRun OnFinish: Copy Data from HMJ_RAS to [iRSDevData].[dbo].[HMJ_RAS] Step
DTSRun: Package execution complete.
Any ideas or solutions?
John Mac Pherson
Database Administrator
Optimal Information Systems Pty (Ltd)
John Mac Pherson
Database Administrator
Optimal Information Systems Pty (Ltd)
jmacpherson@ois.co.za
July 10, 2003 at 8:00 am
This was removed by the editor as SPAM
July 14, 2003 at 7:44 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply