I have developed an C# windows application, which uses Microsoft.SqlServer.DTSPkg80.dll for import data from a text file. For this, I added references to Microsoft.SqlServer.DTSPkg80.dll . This works fine through sourcecode and exe in my development pc and I want to move the windows application to production by
building a windows installer (packaging and deploying) through setupwizard and it is successfull. I installed my set up to another computer and try to run it, however I got the error
"COM object with CLSID{......} is either not valid or not registered" when it comes to Microsoft.SqlServer.DTSPkg80.dll . Anything should I add in the references? Or Install any components OR missing any dlls? Pls. Help me.

Thanks for all your help.

Hi, Kathy!

Unfortunately, I am having the same problem in .NET. In short, it is b/c MS's wonderful Dependencies detection in the setup project is not detecting (by design?) the COM object being used to execute the DTS that is actually a part of the install for SQL Server. Your program will work fine if you install SQL Server first. If you do find out the dependency(ies) that is/are missing, please let me know (and vice versa, of course). Take care,


James