opc.three (6/7/2012)
Koen Verbeeck (6/7/2012)
opc.three (6/6/2012)
The marketing material says you can, but I have not tried it so could not say how accurate the claims are.I don't think you can create a package in SQL 2012 and then run it on a SQL Server 2008.
You can create a 2012 package that connects to 2008 but still runs on a 2012 server.
You're right. Here is the article I was thinking of: SQL Server Data Tools FAQ. It was database project targeting I was thinking of.
In the FAQ it says: SSDT targets: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Azure.
As I see it you can develop SSIS-packages in SQL Server Data Tools and deploy it in SQL Server 2008.