• 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