I have an SSIS package (SQL Server 2005/VS 2005) which works quite well on my local server. I was trying to deploy it to a customer's server. Before deploying I need to open the project in VS and make some changes. When I try to open it on their server I get the error: Unable to cast COM object of type 'System.___ComObject' to interface type 'Microsoft.SQLServer.Dts.Pipeline.Wrapper.IDTSobject90' what's up with that???

And they have Visual Studio installed on their SERVER? When you say "open it on their server", what exactly are you openning it with?Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

On their server I use VS that is installed along with SQL Server. Iv'e had no problems working with my SSAS project on their server.

Is it possible that you didn't install the SSIS components? Or that their server is 64-bit, and you didn't install the 32-bit components? (BIDS/VStudio is 32-bit.) Talk to me now on

Those are both probabilities. I made the changes to SSIS on my server and copied it back, avoiding the necessity to open it on their server's BIDS. So I did and end run around the problem. If I have problems in the future I'll check to see what components were installed. Thanks.