?
Solved

convert ssis from v2012  to v2008 R2

Posted on 2014-01-02
2
Medium Priority
?
1,456 Views
Last Modified: 2016-02-10
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.
0
Comment
Question by:patd1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 1500 total points
ID: 39754712
You can't auto-convert a 2012 package to 2008R2 - in fact, you can't auto-convert any of MS' SSIS packages backwards between any versions - only forwards. The option simply doesn't exist!

Your best way - from experience of just this thing - is to sit yourself down with two development machines beside each other. Have one with 2008 and the other set up with 2012; bring up the 2012 solution in one and start a new 2008 solution in the other. Use the 2012 version as a script and replicate it in the 2008 system.

Why two machines? Because SSIS versions can overwrite each other in installation, meaning that it can be difficult to get both running on the same machine. 2005 and 2008 were like that: I never tried running 2008R2 and 2012 on the same machine - I had better things to do with my time :)

Good luck

Mike
0
 

Author Closing Comment

by:patd1
ID: 39798154
I wish there was a way.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question