SSIS package migration from 2005 to 2008 error

• scorpnit

  Old Hand

  Points: 369

  More actions

  January 26, 2010 at 2:52 pm

  #214888

  Hello,

  We developed SSIS packages in SQL Server 2005 and now migrating them to SQL Server 2008. To do that, we are opening the SSIS package directly in SQL Server 2008 BIDS. By doing that, we get the error as shown below:

  Error7Error loading ABC.dtsx: The component metadata for "component "Script Component" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. C:\ABC.dtsx11

  The error is on the SCRIPT COMPONENT within "Data flow Transformations". The script is used to capture error occured in ANY of the step within the SSIS package.

  Please help in getting this resolved as we have around 180 SSIS packages to be converted.

• January 27, 2010 at 4:46 am

  This was removed by the editor as SPAM

• scorpnit

  Old Hand

  Points: 369

  More actions

  January 27, 2010 at 8:25 am

  #1109334

  Hello,

  This is used as data source.

• January 28, 2010 at 3:55 am

  This was removed by the editor as SPAM