I am trying to deploy an SSIS package created in Visual Studio 2005 to a SQL Server 2005 server. When I run the package installation wizard that I built I get the following error...
TITLE: Package Installation Wizard
--------------------------
----
Could not save the package "C:\Documents and Settings\jsigmon\Desktop\B
oard SSIS\Board SSIS\bin\Deployment\PriceA
nnualOverr
ide.dtsx" to SQL Server "TIC-BAAN".
--------------------------
----
ADDITIONAL INFORMATION:
Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported.
--------------------------
----
Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported.
--------------------------
----
BUTTONS:
OK
--------------------------
----
I have Microsoft Visual Studio 2005 and 2008 along with SQL Server 2005 and 2008 installed on my development machine. By design, SQL Server 2005 toolset should be used to deploy SSIS packages to SQL Server 2005 and SQL Server 2008 toolset should be used to deply SSIS packages to SQL Server 2008. How do I use the PATH environment variable to decide whether 2005 toolset or 2008 toolset should be used. I tried going to My computer and setting the path environment but that didn't work.
2008 toolset are in %PROGRAMFILES%\Microsoft SQL Server\100\DTS\Binn
2005 toolset are in %PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn
Start Free Trial
