Post reply

DTS - Invalid Class String Error

  • July 7, 2003 at 3:28 am

    #106183

    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)

    jmacpherson@ois.co.za


    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

    #465312

    Hi,

    Is this you problem?

    http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q188/2/89.asp&NoWebContent=1

    JFB

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply