DTS - Invalid Class String Error

[osjohnm]

Hi all

One of our developers is busy creating DTS packages that copies a table from another database and then renames the previous table instead of overwriting it if it already exists like so:

HMJ_RAS
HMJ_RAS_01a
HMJ_RAS_01b

On one package this works fine without any problems but the others which were saved from the working one and then he added the rename tasks. The table is created but not data is populated.

This is the error:

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.

I've searched microsoft and google and what I've found hasn't answered my question

I appreciate any help

Thanks

John