dbTalk Databases Forums  

Creating DTS packages with VB.NET and DB2

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


Discuss Creating DTS packages with VB.NET and DB2 in the microsoft.public.sqlserver.dts forum.



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

Default Creating DTS packages with VB.NET and DB2 - 10-11-2005 , 09:26 AM






Hello, I would like to use the DTS object model and VB .NET to create DTS
packages to connect to DB2 and export data to CSV and XLS formats as well as
import data from CSV or XLS into DB2 tables.

Can anyone point me to VB .NET code sample that do this (or something
similar)?

Regards,

Ric

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Creating DTS packages with VB.NET and DB2 - 10-11-2005 , 09:48 AM






Create a sample package, then use Save As VB to get some VB6 code. This
should serve as a good base line for you.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Ric" <Ric (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello, I would like to use the DTS object model and VB .NET to create DTS
packages to connect to DB2 and export data to CSV and XLS formats as well
as
import data from CSV or XLS into DB2 tables.

Can anyone point me to VB .NET code sample that do this (or something
similar)?

Regards,

Ric



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.