To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.
Course Of The Month
2 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
running SQL 2012 SSIS packages in recent versions?
Posted on 2016-08-03
Hi,
I have two questions >>
I created SSIS packages in SQL Server 2012 data tools. Will those SSIS packages run in SQL server 2014 and 2016 data tools?
SQL Server 2016 - is that a same install like 2012? 2016 is not web based like office 365, correct?
I have two questions >>
I created SSIS packages in SQL Server 2012 data tools. Will those SSIS packages run in SQL server 2014 and 2016 data tools?
SQL Server 2016 - is that a same install like 2012? 2016 is not web based like office 365, correct?
[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
3 Comments
Active today
SQL Server 2016 - is that a same install like 2012? 2016 is not web based like office 365, correct?
Correct. Its like 2012 only and not Web based.
I created SSIS packages in SQL Server 2012 data tools. Will those SSIS packages run in SQL server 2014 and 2016 data tools?
According to MSDN its possible (https://msdn.microsoft.com/en-us/library/bb522577.aspx)
On an instance of SQL Server 2014, you can import packages from an instance of SQL Server 2008 or from an instance of SQL Server 2012, but you cannot export packages to an instance of SQL Server 2008 or to an instance of SQL Server 2012.
Run packages. You can run SQL Server 2008 Integration Services and SQL Server 2012 Integration Services packages by using the SQL Server 2014 version of the dtexec utility or of SQL Server Agent. Whenever a SQL Server 2014 Integration Services tool loads a package that was developed in SQL Server 2008 or SQL Server 2012, the tool temporarily converts, in memory, the package to the package format that SQL Server 2014 Integration Services (SSIS) uses. If the SQL Server 2008 or SQL Server 2012 package has issues that prevent a successful conversion, the SQL Server 2014 Integration Services tool cannot run the package until those issues are resolved. For more information, see Upgrade Integration Services Packages.
Active 6 days ago
just FYI
if you have "normal" sql server with installed SQL Server Integration Services (SSIS)
you'll be fine
still - it is good to upgrade SSIS pack to the SQl server version..
--
just FYI
SQL Server with Azure SQL Database
http://social.technet.microsoft.com/wiki/contents/articles/996.this-topic-has-been-retired-sql-server-with-azure-sql-database.aspx
if you have "normal" sql server with installed SQL Server Integration Services (SSIS)
you'll be fine
still - it is good to upgrade SSIS pack to the SQl server version..
--
just FYI
SQL Server with Azure SQL Database
http://social.technet.microsoft.com/wiki/contents/articles/996.this-topic-has-been-retired-sql-server-with-azure-sql-database.aspx
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
In part one, we reviewed the prerequisites required for installing SQL Server vNext.
In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo …
Suggested Courses
Course of the Month2 days, 3 hours left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.