Using ManagedDTS In A CLR

Jul 20, 2006

Hello,

Has anyone been able to create an assembly that references Microsoft.SQLServer.ManagedDTS in a CLR? When I try to do a CREATE Assembly [Microsoft.SQLServer.ManagedDTS] it sets off a chain of dependencies a mile long, (system.windows.forms, system.drawing, accessibility, system.runtime.serialization.formatters.soap, microsoft.sqlserver.msxml6_interop and the list goes on). I have tried creating assemblies for these manually, but they keep referencing more. I have seen a number of posts that talk about using the manageddts in a CLR, but none have mentioned this issue. When I did manage to get all of the assembies created then I got a failure in my CLR procedure because some of the assembly signitures don't match what's in the GAC, even though I am using the only version of the dll that exists on the machine and the versions match. My goal here is to be able to kick off an SSIS package from a CLR function. While the CLR interface is great it still has some issues.

Thank You!
Harry

View 10 Replies


ADVERTISEMENT

Looking For Microsoft.SqlServer.ManagedDTS

Jan 21, 2008

Stupid question. I'm trying to reference Microsoft.SqlServer.ManagedDTS, which allegedly is to be found in Program FilesMicrosoft SQL Server90SDKAssemblies. Except it isn't. Nor is it anywhere on the machine. I know that Integration Services is installed and running - my packages run just fine out of BIDS and via dtexec. Yet I can't find the stupid dll. Clearly I've missed something. Any ideas?

View 12 Replies View Related

Error Using Microsoft.SqlServer.ManagedDTS.dll

May 24, 2007

Hi,



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



C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ManagedDTS9.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

View 8 Replies View Related

Missing Microsoft.SqlServer.ManagedDTS

Aug 30, 2006

Hi

I am trying to run a SSIS package first time through vb.net console application. As the first step, i was trying to add the reference for Microsoft.SqlServer.ManagedDTS assembly but it was not in the available assemblies list box in visual studio 2003!

Please guide what i am supposed to do to get it, or if there any other alternative.



Thanks in advance

Utsav

View 15 Replies View Related

Export Data To Access DB Via ManagedDTS From 64 Bit Platforms

Oct 2, 2007

Hi everybody.

I've seen a lot of stuff regarding 64 bit and Jet drivers. Apparently the only way to overcome this situation is using the command line 32 version of DTEXEC found in C:Program Files (x86)Microsoft SQL Server90DTSBinn. Is that trick what SSIS is using under the cover when it successfully executes my export package? Or is there a mean of building the managed application so it uses the traditional 32 bit libraries of Jet/Access?

I (obviously) prefer using managed code approach when loading and executing SSIS from my end user application. Any suggestion would appreciated.

Thx.

Edelvill

View 3 Replies View Related

Microsoft.SQLServer.ManagedDTS.dll Reference Error In VB.Net 2002

Dec 19, 2006

I am using VB.NET 2002 and we have set up a test environment running SQL Server 2005.

I am trying to add a reference to Microsoft.SQLServer.ManagedDTS.dll which is required to run a DTS/SSIS package from VB.NET.

However the dll does not show in my add reference listing so when I select BROWSE and select the actual DLL I get a rather long error message telling me that only 'dll' and COM components can be referenced.

The exact message is:

A reference to 'C:Programs FilesMicrosoft SQL Server90SDKAssembliesMicrosoft.SQLServer.ManagedDTS.dll' could not be added. This is not a valid assembly or COM component. Only assemblies with extension 'dll' and COM components can be referenced. Please make sure that the file is accessible, and that it is a valid assembly or COM component.



Any suggestions?

thanks

View 3 Replies View Related

Issue Doing Integrated Services Programming Using Microsoft.SqlServer.ManagedDTS.dll

May 23, 2007

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

View 9 Replies View Related

Do I Need License For Using SSIS Library (Microsoft.SQLServer.ManagedDTS) On Machine Where SQL Express Is Installed

Nov 19, 2007



I am working to develop an application using dotnet framework 2.0 that requires loading tab delimited text file (generated on each user action) in to table of SQL Express database. I am thinking to use SSIS library (Managed DTS) to call my SSIS package from within my application to load this data on each user transaction. This should be noted that I am not hosting my packages in to SQL Express.

Microsoft allows redistribution of SQL Express for free. Do I need any SQL Server or any other type of license for using SSIS library from my application?

-Faisal

View 5 Replies View Related

Can't Create A Setup Project For Project Referencing Microsoft.SqlServer.ManagedDTS

Feb 3, 2007

I have a very small project written in VB.Net 2005 using the SQL Server 2005 SSiS DTSx package.

I took a SQL Server 2000 dts package and using the SQL Server 3005 legacy tools migrated it so I could still use the package withing SQL 2005 until I can build one using BI/SSIS.

Anyway,I added the reference Microsoft.SqlServer.ManagedDTS so I could then use the Microsoft.SqlServer.Dts.Runtime so I can execute the commands:

Dim oApp As New Application
Dim oPkg As New Package
oPkg = oApp.LoadPackage(g_DTSx_Directory & "AOC copy Generic1 CSV to AOC_verify_file_1.dtsx", Nothing)
Dim oResults As DTSExecResult
oResults = oPkg.Execute

Ok. That works fine. Executes without a hitch. So now I try and create a setup project for this and I use the setup wizard.

During the creation of the setup project I get a message that states:
The following files may have dependencies that cannot be determined automatically. Please confirm that all dependencies have been added to the project.
C:windowssystem32msxml6.dll

OK. The dll is part of the reference I mentioned above and I have no idea what other dependencies it may have.

How do I find this out?

Has anyone else created a project like this and experenced the same?

I am on a clean build running WinXP Pro with SP2 - VS2005 with SP1 and the SQL Server 2005 tools.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved