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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Error : Invalid Class String

Author  Topic 

freesoul
Starting Member

35 Posts

Posted - 2007-08-17 : 06:47:41
When trying to migrate a DTS package to SSIS Package ,
it gives error :

Erro : Invalid Class String

Please suggest .
Thanks in advance !!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-18 : 00:26:25
Take look at Microsoft knowledge base article 912421, it may help.
Go to Top of Page

freesoul
Starting Member

35 Posts

Posted - 2007-08-20 : 03:20:30
I have already tried that option ...
but even after tring that i got the same error ...
any other way to get it done ...

thanks for the response :)
Go to Top of Page

freesoul
Starting Member

35 Posts

Posted - 2007-09-10 : 10:43:51
I am sending the Error Log file for this DTS to SSIS migration :

LogID=3
#Time=7:48 AM
#Level=DTSMW_LOGLEVEL_ERR
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message= at DTS.Connection.get_ConnectionProperties()
at Microsoft.SqlServer.Dts.MigrationWizard.ConnectionsMigrationModule.ConnectionsMigration.MigrateConnections(Connection shilohConnection, Package& yukonPackage)
at Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework.MigrateConnections(DTS8Package shilohPackage, Package& yukonPackage)

LogID=4
#Time=7:48 AM
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=User terminated migration.

LogID=5
#Time=7:48 AM
#Level=DTSMW_LOGLEVEL_ERR
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Microsoft.SqlServer.Dts.MigrationWizard.HelperUtility.DTSMWException: Invalid class string
---> System.Runtime.InteropServices.COMException (0x800401F3): Invalid class string

at DTS.Connection.get_ConnectionProperties()
at Microsoft.SqlServer.Dts.MigrationWizard.ConnectionsMigrationModule.ConnectionsMigration.MigrateConnections(Connection shilohConnection, Package& yukonPackage)
at Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework.MigrateConnections(DTS8Package shilohPackage, Package& yukonPackage)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework.ReportError(Exception ex, String errorText, String packageName, String packageEllement)
at Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework.MigrateConnections(DTS8Package shilohPackage, Package& yukonPackage)
at Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework.StartMigration(PackageInfo pInfo)

Hope this could help some1 figure out the root cause???
Thanks anyways !!!!
Go to Top of Page
   

- Advertisement -