I have developed a set of packages which i am attempting to deploy to a server which i did not configure.
The Server has three versions of SQL installed - SQL 2000 (default), 2005 and 2008.
When i run my deployment manifest i receive an error: 0xC0011008 - I think this is because my package is developed in BIDS 2008 and the server is running SSIS 2005.
This is my issue....when I look in the services on the server - i have two integration services, both running (i didn't think this was possible?)
1. SQL Server Integration Services
2. SQL Server Integration Services 10.0
When i connect to Integration Services through SSMS - the version displayed is 9.0.4035
There is also no DTS directory under the C:\Program Files\Microsoft SQL Server\90\ or C:\Program Files\Microsoft SQL Server\100 directory ....?
How can i rectify this? I want to end up with SSIS 2008 installed.
View Complete Post