dbTalk Databases Forums  

DTS in .NET

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS in .NET in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John Koswalski
 
Posts: n/a

Default DTS in .NET - 01-25-2004 , 04:09 AM






Hello,

What is the diference between calling the DTS library from VS .NET by
addinga a reference to the COM object and creating a RCW yourself and then
reffering to that? DOes .NET build a RCW for you behind the scenes when you
select the COM object in the references? What are tbe benefits and
drawbacks of both approaches?

Thx



Reply With Quote
  #2  
Old   
Gert E.R. Drapers
 
Posts: n/a

Default Re: DTS in .NET - 01-25-2004 , 04:29 PM






Visual Studio builds one on the fly when you add the reference. They should
be identical in terms of functionality, but:
1) Visual Studio will create on for every project, if you have lots of
projects referencing the same COM object you have a lot of disk bloat going
on
2) You might want to strongly sign your COM wrapper and place it in the GAC,
Visual Studio will not do this for you, you have to do this manually
3) I personally like to create them manually since you know exactly which
flags and options are used and it is no-hidden magic from the IDE, which I
hate, because it has bitten me more then once before

GertD (AT) SQLDev (DOT) Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.

"John Koswalski" <john.koswalski (AT) perfectitsolutions (DOT) nl> wrote

Quote:
Hello,

What is the diference between calling the DTS library from VS .NET by
addinga a reference to the COM object and creating a RCW yourself and then
reffering to that? DOes .NET build a RCW for you behind the scenes when
you
select the COM object in the references? What are tbe benefits and
drawbacks of both approaches?

Thx





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.