Post reply

Can a SSIS package developed in SQL Server 2016 be run on SQL Server 2008

  • June 23, 2020 at 2:10 pm

    #3764798

    hi there

    I have developed an SSIS package in Visual Studio 2017. The Target Server Version  is SQL Server 2016.

    I have been told that this will now have to be run on a SQL Server 2008

    Is there a way that I can downgrade my package to be run on SQL Server 2008 or will this package have to be refactored in Visual Studio 2008 BIDS?

     

     

  • June 23, 2020 at 2:14 pm

    #3764800

    you need to redo it on 2008 BIDS.

    2012 and higher its easier to "change" but 2008 to 2012 was a major change of SSIS Engine

  • June 23, 2020 at 2:15 pm

    #3764801

    SSDT doesn't support SQL Server 2008, you have to use BIDS, which pre-dates SSDT. The deployment methods are also quite different, as there's no support for SSISDB. Considering that SQL Server 2008 is completely unsupported, the real solution here is getting the old instance upgraded to a supported one.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply