BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 12 March 2014
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Working with Integration Services 2008 and 2012 (SSIS)
Following a recent course, I thought I'd share answers to some questions with the wider world!
You can see a list of what's new in SSIS 2012 here.
Can you import SSIS 2012 packages into SSIS 2008?
Alas, I think not. If you're in 2008 R2, you can import packages as follows. First choose to add an existing package:
First choose to add a package to a project.
Choose where it's coming from:
Choose to get the package from your computer's hard disk.
You can now choose a package file:
Click on the button shown to find and choose the package you want to import.
So far, so good, but now's when it all goes pear-shaped (a strange saying to describe things going wrong, as pears are reasonably well-formed ...):
Part of the error message which appears.
After some Googling, it appears that not many people want to move packages from a later version of SSIS to an older one, but I did find this Microsoft site which suggests it's not possible:
Although this is talking about packages stored in SQL Server, I assume the same thing applies to all packages - it looks like exporting is not downwardly compatible.
This StackOverflow article also suggests that it can't be done.
Can you use parameters in SSIS 2008 R2?
No - the concept doesn't exist.
What a parameter allows you to do is to pass information to a package at the time that you run it. In older versions of SSIS (ie before 2012) the only way to do this is by setting the value of package variables in a configuration file.
Deploying SSIS 2012 versus earlier versions
There are two main approaches to deploying an SSIS package - project deployment and package deployment:
Switching deployment methods in SSIS 2012 (in earlier versions of SSIS project deployment doesn't exist as a concept).
Here is a quick comparison of the two methods:
|Project||Introduced in SSIS 2012 - use by preference, as it's much simpler and more powerful. Projects are deployed to the SSIS catalog, which you can manage in Management Studio. You can use parameters to pass information to packages when you execute them, and group parameters together using environments.|
|Package||Works in all versions of SSIS. You tell SSIS to create a deployment manifest when you build a package, and then send the manifest file created to anyone who wants to deploy your package.|
A final recommendation - screen design differences
Finally, if anyone reading this is wondering whether they should upgrade, the answer is emphatically yes! If not for any of the above reasons, then because the user interface is so much nicer in 2012:
|A 2008 package running||The same, but in 2012|
Which would you rather see on your screen?