Contents
What is the difference between SSIS 2008 and 2012?
The major difference that has come up in SSIS 2012 is a new deployment model called project deployment model. As per this package is no longer a basic unit but its the project. When you use this deployment model you can deploy project from Visual Studio/SSDT environment directly to the server.
How old is SSIS?
First released with Microsoft SQL Server 2005, SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0. Unlike DTS, which was included in all versions, SSIS is only available in the “Standard”, “Business Intelligence” and “Enterprise” editions.
What happens to SQL Server 2008 integration services?
The upgrade process does not remove the SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 (11.x), or SQL Server 2014 (12.x)tools. However, you will not able to use these tools to continue to work with SQL Server 2008 Integration Services (SSIS) or later packages on a server that has been upgraded.
How to enable SSIs in SQL Server 2008?
On Feature Selection step of SQL Server 2008 R2 Setup, you need to decide what you would like to install. If you need only the Business Intelligence Development Studio for SSIS packages development, then install only the Business Intelligence Development Studio.
How to check the version of SQL Server integration services?
Identify the version of packages in the msdb.dbo.sysssispackages system table by checking the value in the packageformat column. The table has a packageformat column that identifies the version of each package. A value of 3 indicates a SQL Server 2008 Integration Services (SSIS) package.
What happens when you change the target version of SSIs?
Once the target version is set, the SSIS toolbox will adapt accordingly. For example, in SQL Server 2016 there are new Hadoop tasks available and you can download Azure tasks from the Azure feature pack. When setting the version to SQL Server 2014, all those new tasks will disappear from the SSIS Toolbox.