Hi all, ihave both SQL 2005, 2008R2 on my machine. when i am trying to deploy manifest file , automatically it is taking 2008..so i am getting an error ..please help me how to select with 2005 . 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. Thanks in advance Jyo

It is the PATH environmental variable which drives this. Temporary switch the following directories around: this %PROGRAMFILES%\Microsoft SQL Server\100\DTS\Binn with %PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn so the last to 90 AKA SQL Server 2005) precedes the one to SSIS 2008Arthur My Blog

One thing to keep in mind is that many programs obtain the environmental variables when they're first started, so while windows may not need a restart, some programs might before they'll be able to use the new variables.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker