locked
VS 2012 and SSIS 2008 RRS feed

  • Question

  • Hi!

    I have installed VS 2012, SSDT 2012 and SSDT BI 2012 and I thought it would be possible to deploy a SSIS package to a SS 2008 database server. But that seems to be not possible. Is that right?

    Upon deployment the error message says that the two versions (SSIS package and database server) are different and that is not supported.

    The other project types (SSRS and database projects) are backwards compatible what I can see but not SSIS.

    How am I supposed to work with SSIS packages that need to be run on a SQL Server 2008 server using VS 2012, do I have to keep VS 2008?

    Thanks in advance!

    Best regards
    Lars

    Monday, May 27, 2013 2:55 PM

Answers

  • SSIS 2008 is only supported using VS2008 BI Studio (BIDS).

    The SSIS support in SSDT hosted in VS2010 or VS2012 only support the SQL 2012 SSIS package format. I was told this was due to the fact that the SSIS package format changed in SQL 2012.


    -GertD @ www.sqlproj.com

    • Marked as answer by Lars Lindgren Wednesday, May 29, 2013 6:16 AM
    Wednesday, May 29, 2013 5:30 AM
    Answerer

All replies

  •  I thought it would be possible to deploy a SSIS package to a SS 2008 database server.

    Hello Lars,

    You can create packages for SS (SQL Server) 2008 in SSDT, but not packages for SSIS (Integration Service) 2008.


    Olaf Helper

    Blog Xing

    Tuesday, May 28, 2013 4:39 PM
  • Hi Olaf!

    What do you mean that I can create packages in SSDT for SS 2008? What type av packages are you refering to?

    Thanks in advance!
    Best regards
    Lars

    Tuesday, May 28, 2013 6:28 PM
  • SSIS 2008 is only supported using VS2008 BI Studio (BIDS).

    The SSIS support in SSDT hosted in VS2010 or VS2012 only support the SQL 2012 SSIS package format. I was told this was due to the fact that the SSIS package format changed in SQL 2012.


    -GertD @ www.sqlproj.com

    • Marked as answer by Lars Lindgren Wednesday, May 29, 2013 6:16 AM
    Wednesday, May 29, 2013 5:30 AM
    Answerer