SSIS package upgrade 2005 - 2012

• SQLAssAS

  SSCertifiable

  Points: 7246

  More actions

  March 12, 2014 at 8:50 am

  #289233

  I am trying to upgrade some packages from SSIS 2005 - 2012.

  I am aware there is an issue between going from 32bit to 64bit, and that the packages need upgrading from SQL 2005 32bit - SQL 2012 32bit and then onto 64bit.

  Is the error I am getting part of this issue?

  Error attached

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  March 12, 2014 at 11:16 am

  #1696491

  Most probably, No. Are your package calling any .NET assembly ?

  --

  SQLBuddy

• ashish.shevale

  Ten Centuries

  Points: 1177

  More actions

  March 13, 2014 at 12:46 am

  #1696665

  as sqlbuddy said

  If you are using an custom dot net assembly try removing it from script task and upgarde and once done add it back

  ------------------------------------------------------------------------------------

  Ashish