Search code examples
visual-studiosql-server-2008-r2sql-server-data-tools

Cannot Import DTSX files back into SQL Server 2008r2 Int Services after export and edit in VSPro2013


I've carried out a lot of work here and want to be able to use my DTSX packages

But I get the version incompatibility and the Error message is specific

But there must be some way I can run my packages. They appear to not be able to be run from within VS2013 Pro editor

My question is, what do I need to install exactly to all allow me to execute these saved packages?

By asking here i can save time since there are many versions and many add ons etc


Solution

  • First - how to run a SSIS 2008 package?

    There is a good overview here, by Ashish Kumar Mehta of MSSQTips, on how to execute packages both remotely on the server or locally. Either way you need the SQL Server Client Tools installed from the SQL Server media (CD, image, etc.). There's no possibility of running a package locally from Management Studio or raw Visual Studio. You can run the package remotely through Management Studio only if that package was stored within the SQL Server. Theoretically, you can run a package in development mode via VS2013, see below.

    Second - how to modify a SSIS 2008 package?

    Unlike subsequent SQL Server (and SSIS) versions, with 2008 you couldn't just use your regular Visual Studio with a downloadable plugin. You had to install one Business Intelligence Development Studio (BIDS), a Visual Studio 2008 derivative (i.e. not a plugin) available on your SQL Server media. That's the way to go if you want to edit the package but also maintain its 2008 version. Otherwise, you're free to upgrade the package to Integration Services 2014 level by several methods, and start hacking at it via Visual Studio 2013 with a downloadable Data Tools - Business Intelligence plug-in. Be advised, it's not possible to convert the package back to 2012 nor 2008 versions.