Post reply

SQL 2012 opening older SSIS packages

  • April 22, 2015 at 9:37 am

    #303210

    I'm sure the SQL Server 2012 can open SSIS packages from older versions of SQL Server. But if you do so it will inevitably prompt you to upgrade. Can I open the older SSIS package without upgrading it? I ask because we've been trying to do that and it hasn't worked. We get stopped at the door. (We're trying to open SQL Server 2008 R2 SSIS packages with SQL Server 2012. It asks if we want to upgrade it, we say no, and that's where it stops.)

    Kindest Regards, Rod Connect with me on LinkedIn.

  • April 22, 2015 at 10:16 am

    #1792813

    I think you can take a copy of those packages and then work on the SQL Server Data Tools. That's how I worked on packages.

  • April 26, 2015 at 7:28 am

    #1793517

    OK thank you, I'll give that a try. Do I open the copy with SQL Data Tools, or are you recommending making the copy just so if I need to I can always go back to the original?

    Kindest Regards, Rod Connect with me on LinkedIn.

  • April 26, 2015 at 10:34 pm

    #1793562

    Hi

    If you proceed with the upgrade, it will make a backup of the old version into a Backup folder of the solution.

    Igor Micev,My blog: www.igormicev.com

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

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