Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

convert ssis from v2012 to v2008 R2 Expand / Collapse
Author
Message
Posted Thursday, January 02, 2014 9:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 31, 2014 10:07 AM
Points: 29, Visits: 93
We have our production server on SQL server 2008 R2 and the plan to upgrade to SQL server 2012 has been delayed because the upgrade on the development environment has ETL performance issues. So, we need to convert some of the SSIS packages that we developed for SQL server 2012 using dev environment, to be to be deployed to SQL server 2008 R2 .

What is the fastest way to convert those SSIS packages? I have installed Visual studio 2008 with BIDS for Sql 2008 R2 on my local machine.

Here is what I tried:
I opened the SSIS package for SQL 2012 on VisualStudio 2010 and midified the code (in code view) as follows:
1) changed the references from 2012 to 2008
2) changed the target framework to 3.5
3) replaced SSIS_ST110 to SSIS_ST100
Now when I try to open this package on Visual studio 2008 I get the following error:

===================================

The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.
(Microsoft Visual Studio)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events)
at Microsoft.DataTransformationServices.Controls.PackageProtectionUtils.<>c__DisplayClass4.<LoadPackageFromFile>b__3(String password, IDTSEvents events)
at Microsoft.DataTransformationServices.Controls.PackageProtectionUtils.LoadPackageWithPassword(PackageLoader loader, IWin32Window dialogParent, String packageName, Boolean askOptionalPassword, String& packagePassword, DtsProtectionEventListener errorListener)
at Microsoft.DataTransformationServices.Controls.PackageProtectionUtils.LoadPackageFromFile(String file, IWin32Window dialogParent, Boolean askOptionalPassword, PackageUpgradeOptions packageUpgradeOptions, String& packagePassword, DtsProtectionEventListener errorListener)
at Microsoft.DataTransformationServices.Controls.PackageLocationControl.LoadPackage(DtsProtectionEventListener errorListener, PackageUpgradeOptions packageUpgradeOptions, String& packagePassword)
at Microsoft.DataTransformationServices.Project.Controls.AddExistingPackageForm.AddExistingPackage(AddExistinngPackageEventListener eventListener)
at Microsoft.DataTransformationServices.Project.Controls.AddExistingPackageForm.AddExistingPackageForm_FormClosing(Object sender, FormClosingEventArgs e)


Thanks for your help.


Forum User
Post #1527200
Posted Friday, January 03, 2014 10:11 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 6:23 AM
Points: 1,135, Visits: 1,149
How many packages do you need to downgrade? If the number is small enough, tour best bet may be just to recreate these in VS/BIDs 2008 R2. I think the changes in the XML between 2008 R2 & 2012 in the .dtsx were fairly large. There may not be an easy way to do this.

I wonder if you could do something with BIML to script these out in 2012, and then recreate them with the BIML in 2008. (Just thinking out load here)

HTH,
Rob
Post #1527644
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse