All geek questions in one place

Run the SSIS package created using VS2008 on SQL Server 2005

Perhaps a stupid question, but ... I created the SSIS package using VS2008 Professional. I want to deploy and execute it on a server running SQL Server 2005. When I try to start it, I get an error when the version Execute Package Utilityon the server is different from the version of the package I'm trying to execute (it makes sense since I created a package with a newer VS version).

As far as I know, Microsoft is not just providing an EPU download for the “upgrade”, since I can execute the package on a server that works with a previous version of SQL Server? Do I need to install an “unpacked” copy of SQL 2008 just to update the package or what? On my workstation (which has VS2008), it works fine with SQL 2005.

+3
source share
3 answers

Unfortunately, you cannot do this. This does not make sense since you can run SSIS for different databases (what if you ran the package on a server that didn’t even use SQL Server?), But you will get this version error if you created it in BIDS 2008.

+3
source

You can try installing the Express version for SQL Server 2008 and see if dtexec enabled is enabled. Unfortunately, the configuration you are trying to run is not supported and is likely to lead to errors.

+1
source

, , , VS2005 SSIS . - VS2008, / 2005 .

?! !?: (

0
source

Source: https://habr.com/ru/post/1703378/

More articles:


All Articles