How to Use .NET Assembly from Legacy SQL Server 2000 DTS

Posted by shyneman on Stack Overflow See other posts from Stack Overflow or by shyneman
Published on 2010-05-13T23:59:21Z Indexed on 2010/05/14 0:04 UTC
Read the original article Hit count: 314

Filed under:

com-interop

|

sql-server-2000

|

dts

|

vbscript

Hi All,

I have a .NET assembly that needs to be called from a DTS package. There are two options I am considering to get this to work:

1) write a COM-callable wrapper for the .NET assembly and have the VBScript create the COM object to use

2) write a .NET command-line exe that uses that .NET assembly and have the VBScript execute that exe

Can anybody comment on the pros/cons of either approach and which is the better way of doing this? If there are other solutions, I'd love to hear them too.

Thanks a lot for any input.

© Stack Overflow or respective owner

Related posts about com-interop

COM Interop without regasm

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm a limited user, and I need to write an Outlook macro that exposes a C# library in Outlook 2003 and 2007. I do not have any admin privilges at all, not even at install time, so I can't run RegAsm and I can't (I assume) write a managed add-in. Is there any way to call .Net code from VBA in this… >>> More
Encrypting using RSA via COM Interop = "The requested operation requires delegation to be enabled on

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys, So i've got this little static method in a .Net class which takes a string, uses some stored public key and returns the encrypted version of that key. This is basically so some user entered data can be saved an encrypted, then retrieved and decrypted at a later date. Pretty basic stuff… >>> More
IIS 7’s Sneaky Secret to Get COM-InterOp to Run

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Originally posted on: http://geekswithblogs.net/DavidHoerster/archive/2013/06/17/iis-7rsquos-sneaky-secret-to-get-com-interop-to-run.aspxIf you’re like me, you don’t really do a lot with COM components these days. For me, I’ve been ‘lucky’ to stay in the managed world for the past 6 or 7 years. … >>> More
.NET COM Interop with references to other libraries

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello,I'm up against a problem when loading a class in a managed library from a COM Interop library. basically I have some Unmanaged C++ code and a COM Interop library written in C#. And finally a 3rd library which is referenced by the COM Interop library which contains a class: public class MyClass{ … >>> More
Does COM interop respect .NET AppDomain boundaries for assembly loading?

as seen on Stack Overflow - Search for 'Stack Overflow'
Here's the core problem: I have a .NET application that is using COM interop in a separate AppDomain. The COM stuff seems to be loading assemblies back into the default domain, rather than the AppDomain from which the COM stuff is being called. What I want to know is: is this expected behaviour,… >>> More

Related posts about sql-server-2000

sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More
SQLAuthority News – 2 Security Updates for SQL Server 2000 SP 4 Users

as seen on SQL Authority - Search for 'SQL Authority'
If you are using SQL Server 2000 still today my very first recommendation to you is to upgrade to SQL Server 2012. SQL Server 2000 is now 12 years old product and since then many new enhancements as well features which are relevant to current growth and progress in Informational Industry. Now is the… >>> More
Syncsort's Backup Express Supports SQL Server 2000 and DB2-UDB in SAP Solution Environments

as seen on Internet.com - Search for 'Internet.com'
A SQL Server 2000 and a DB2-UDB SAP Solution Environment Integration Assessment of Syncsort Incorporated's enterprise data backup and restore product, Backup Express, asserted that Backup Express provides high value to SAP customers. >>> More
SQL Server 2000 (8.0) SP 4 crash after load Linked Servers

as seen on Server Fault - Search for 'Server Fault'
Hello I configured one Oracle 10g Linked Server on my SQL Server 2000, so two days ago I can view the tables and views, today when I try to check it again I get an connection error, something with latency and time out operation "readsni" in the process of login the sa user. Then I lost all connections… >>> More
SQL Server 2000 incorrect message: duplicate key with unique index

as seen on Stack Overflow - Search for 'Stack Overflow'
Database server: SQL Server 2000 - 8.00.760 - SP3 - Standard Edition I have a table with 5 columns, in which I want to add a large (300.000) number of records. There is a unique index on the combination of two columns. If I add the records with this unique index in place, SQL Server gives this error… >>> More