Error using Microsoft.SqlServer.ManagedDTS.dll

Hi,

I picked the Microsoft.SQLServer.ManagedDTS.dll from following folder:

C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91>

Similarly picked Microsoft.SqlServer.DTSRuntimeWrap.dll also.

I added it as reference in my .NET application.

When I execute the program I get below error:

Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.

Any Clue?

Application executes from a machine where SQL Server 2005 is not installed.

How to get the RunningPackages information back to a client PC?

HV

Hiral wrote:

Application executes from a machine where SQL Server 2005 is not installed.

How to get the RunningPackages information back to a client PC?

This seems like the most likely problem. You can only work with the SSIS runtime on machines where SSIS (a server component of SQL Server 2005) is installed. There is no redistributable package for SSIS like there was for DTS.

|||

Thank you Matthew.

But then what's the point giving Intergration Services Programming object model?

It's given by microsoft to program around packages.

Please refer the below links:

http://blogs.msdn.com/michen/default.aspx

http://msdn2.microsoft.com/zh-tw/library/ms136025.aspx

My point of concern is how do we get the dll "Microsoft.SqlServer.ManagedDTS.dll" ?

HV

|||

Hiral wrote:

Thank you Matthew.

But then what's the point giving Intergration Services Programming object model?

It's given by microsoft to program around packages.

Please refer the below links:

http://blogs.msdn.com/michen/default.aspx

http://msdn2.microsoft.com/zh-tw/library/ms136025.aspx

My point of concern is how do we get the dll "Microsoft.SqlServer.ManagedDTS.dll" ?

HV

You install SQL Server Integration Services. That is how you get Microsoft.SqlServer.ManagedDTS.dll. Both of the links you provided discuss using the SSIS object model, but neither (that I can see) says anything about installing this DLL on a non-SQL Server computer.

|||Here's another link that seems relevant: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1647966&SiteID=1&mode=1|||

Thank you Matthew.

I agree with you that the link I provided does not mention anything about having the ManagedDTS.dll without sql server installation.

That's the reason I have posted it so that I get some help on how to get that dll.

Another thing is though the links say that ManagedDTS.dll is shipped with SQL Server 2005, I searched for it on our database server and it was not found.

My point is how do I get this dll? Which installation will help me out for it? What is the process I should follow to get it?

HV

|||

Hiral wrote:

Thank you Matthew.

I agree with you that the link I provided does not mention anything about having the ManagedDTS.dll without sql server installation.

That's the reason I have posted it so that I get some help on how to get that dll.

Another thing is though the links say that ManagedDTS.dll is shipped with SQL Server 2005, I searched for it on our database server and it was not found.

My point is how do I get this dll? Which installation will help me out for it? What is the process I should follow to get it?

HV

You need to install SSIS explicitly. SSIS comes with Standard, Developer, and Enterprise versions of SQL Server 2005.

You get the dll by installing SSIS.|||

Thank you Phil.

The thing is SSIS is installed on our database server still we do not have Microsoft.SQLServer.ManagedDTS.dll on that machine.

Any clue on this?