Hi,
I am writing an installer code in C# to deploy the SSIS package.
I want to use Microsoft.SqlServer.ManagedDTS.dll for it.
It is mentioned in few articles available online that Microsoft.SqlServer.ManagedDTS.dll ships with SQL Server 2005.
I searched on our database server but could not get it.
Anyone having idea on this please help.
HV
Don't try and install SSIS by hand, it is not a good idea It is not supposed to be a redistributable component. There are a lot more assemblies that just that one for SSIS.
Since SSIS requires a full SQL Server license, why not use the regular SQL setup to do this for you. You can choose which servers you want.
If you have installed SSIS on your server then it will certainly be in the GAC, but it may not be on the file system outside of this, unless you installed the tools, in which case it is - C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies
|||Another question to ask: Is SSIS installed on this SQL Server box? A lot of SQL 2005 servers will be set up by their DBAs to not have any unnecessary components installed, and SSIS sometimes falls into this category.|||Hi,
Thank you Darren.
SSIS is installed on the machine.
I checked the following folder :- C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies
but dll is not available.
Which tool installation delivers Microsoft.SqlServer.ManagedDts.dll?
Please let me know.
HV
|||Hi,
Thank you Mathew.
SSIS is installed on the machine.
I checked the following folder :- C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies
but it's not available.
HV
|||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?
How to get the RunningPackages information back to a client PC?
HV
|||If you want running packages information, why not just use the MS tools?
Do you have SSIS tools installed on the local machine that hosts the program? The error indicates that Microsoft.SqlServer.DTSRuntimeWrap is not installed on the local PC?
|||No SSIS is not installed on the machine which hosts program.
But that is my requirement , I want to deploy SSIS package remotely.
I have installed Microsoft.SQLServer.DTSRuntimeWrap.dll in GAC.
Let me know if there is a way out to use it on a machine where SSIS is not installed.
HV
|||SSIS is not installed you say, and you get an error that says in cannot find a COM component. Do you think there may be a connection?
I refer you to my original post, apart from saying that a manual install was a silly idea, I also pointed out "There are a lot more assemblies that just that one for SSIS."
As a start point that DLL is just a wrapper to the COM library that does the work, the name hints at that, and the error proves that it is trying to use a COM DLL that is not there, a COM DLL with a ProgID of {E44847F1-FD8C-4251-B5DA-B04BB22E236E} perhaps. As I said before there are lots of DLLs involved in SSIS not just one, so use a proper install.
What you are asking for a not a supported scenario, you may be violating your license agreements if not careful, and at any rate will be a very complicated task to try and reverse engineer the requirements, and very slow if you cannot track a missing COM DLL down yourself.
If you think this is wrong, post feedback to MS (http://connect.microsoft.com) telling them why you think you should have some redistribuatable support, but in the mean-time you will need to run one of the MS installs to get this to work.
Why do you not want to use a MS install?
No comments:
Post a Comment