Jan.Sundbye (6/8/2012)
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.
SSDT <> SSIS
And as I said before, you can create a package that connects to earlier versions of SQL Server, you just cannot run the package on such a server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP