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 2008 Forums
 SSIS and Import/Export (2008)
 SSIS Package upgrade from 2005 to 2008

Author  Topic 

Mandeep2003
Starting Member

1 Post

Posted - 2011-03-15 : 04:34:22
Dear All,

We are facing some issues in SQL server upgrade from 2005 to 2008 as below :

In our project we are upgrading SQL server from 2005 to 2008 . We have some SQL jobs as well which are invoking SSIS packages.

Since these are 2005 SSIS packages , we need to upgrade them as well. Following are the steps we carried out for their

Upgradation :


We got SQL server 2008 client tools installed on testing machine .
We used SQL server 2008 upgrade wizard to upgrade 2005 SSIS package to 2008 SSIS package. This upgradation went fine
For majority of the packages. But in some of the packages script components were being invoked on failure events , these components are not getting upgraded and we are getting the attached errors. Also we are not getting an option to open these script components in Edit mode.


Below are the set of errors we got for this script component named XFM_SCR_ErrorRecord :

Error 3 Error loading PKG_LOADFact_ISL_GAAP.dtsx: System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER)) at EnvDTE80.Solution2.SaveAs(String FileName) at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String languageID, String projectname, String projectext, Boolean bCleanupOnClose) at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String languageID, String projectname, String projectext) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.MigrateVsaToVsta() at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PerformUpgrade(Int32 pipelineVersion) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper100 wrapper, Int32 lPipelineVersion) d:\documents and settings\mkauu\My Documents\Visual Studio 2008\Projects\ISL-GAAP-2008\ISL-GAAP-2008\PKG_LOADFact_ISL_GAAP.dtsx 1 1




Error 8 Validation error. DFT_Fail_Package SSIS.Pipeline: The component metadata for "component "XFM_SCR_ErrorRecord" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. PKG_LOADFact_ISL_GAAP.dtsx 0 0


Error 4 Error loading PKG_LOADFact_ISL_GAAP.dtsx: The component metadata for "component "XFM_SCR_ErrorRecord" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. d:\documents and settings\mkauu\My Documents\Visual Studio 2008\Projects\ISL-GAAP-2008\ISL-GAAP-2008\PKG_LOADFact_ISL_GAAP.dtsx 1 1



Error 1 Validation error. DFT_Fail_Package: DFT_Fail_Package: The component metadata for "component "XFM_SCR_ErrorRecord" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. PKG_LOADFact_ISL_GAAP.dtsx 0 0


Hope some kind souls will help us on this .


~Mandeep
   

- Advertisement -