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

Question

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.