I am developing a SSIS 2008 R2 package in Visual Studio 2015 using SQL Server Data Tools and i am getting the error listed below. Is these two truly not compatible or is there a setting I can change (or workaround)?
Asked
Active
Viewed 312 times
2
Hadi
- 36,233
- 13
- 65
- 124
Steve Salowitz
- 1,283
- 1
- 14
- 28
-
2You can deploy a ssis 2008 r2 package only using visual studio 2008. The answer provided is 100% correct – Yahfoufi Apr 29 '17 at 03:27
1 Answers
2
You cannot build a ssis package for sql server 2008 r2 with VS 2015.
According to this Microsoft Docs article you can build a sql server 2008 r2 ssis package with only visual studio 2008 (business intelligence developpment studio).
There are a lot of links saying that newer versions of visual studio cannot deploy SSIS 2008 packages correctly:
- Can SQL Server Data Tools work with SQL Server 2008 SSIS?
- https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bff5e145-1c63-4221-b2ba-009ea96a9e05/can-i-use-vs2012-to-create-and-deploy-ssis-for-sql2008r2?forum=sqlintegrationservices
- https://www.sqlservercentral.com/Forums/Topic1560322-364-1.aspx
