Call to GetDtsServerPackageInfos fails with the message Class not registered
I have written a WPF application that lists all the SSIS packages stored on a SQL instance. It works fine when I point it at an instance of SQL 2005. However, when I point the application at a SQL 2008 SSIS instance, that I can connect to from the same machine
using SSMS, I get the error message:
"Class not registered"
This happens when I make the call to the GetDtsServerPackageInfos method of the application object.
Any idea how I can make this work with SQL 2008?
November 9th, 2010 5:13pm
Hi SyedRehman,
If I am correct, you are using SQL Server Integration Services(SSIS) 2005 runtime to connect to the SSIS 2008 server. I can reproduce the issue in this scenario.
If so, the error is expected. By design, we are unable to connect to SSIS 2008 using SSIS 2005 runtime.
To fix the issue, please use SSIS 2008 runtime instead. In other words, please add the reference to Micrsoft.SQLServer.ManagedDTS 10.0.0.0 instead of 9.0.242.0 in the WPF project.
If you have any more questions, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2010 10:36pm