dbTalk Databases Forums  

Call DTS with SQL DMO in C#

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


Discuss Call DTS with SQL DMO in C# in the microsoft.public.sqlserver.dts forum.



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

Default Call DTS with SQL DMO in C# - 11-07-2003 , 10:22 AM






Hi,
I'm trying to import/export data between SQL Server,
..dbf file and text file by using SQL-DMO in C#.
Is there anyway I can call "DTS Import/Export Wizard"
from C# program?
I know how to use existing DTS packages, but I need to add
user interface.

I think one of DTS method or function should do this,
but I could find which one.

Any suggestion?

Thank you.

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Call DTS with SQL DMO in C# - 11-07-2003 , 10:52 AM






Have a look at SQL NS
SQL-DMO has next to nothing to do with DTS.

http://www.sqldev.net/sqlns.htm
http://tinyurl.com/u36x
--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"hrhoe" <hrhoe (AT) hotmail (DOT) com> wrote

Quote:
Hi,
I'm trying to import/export data between SQL Server,
.dbf file and text file by using SQL-DMO in C#.
Is there anyway I can call "DTS Import/Export Wizard"
from C# program?
I know how to use existing DTS packages, but I need to add
user interface.

I think one of DTS method or function should do this,
but I could find which one.

Any suggestion?

Thank you.



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

Default Re: Call DTS with SQL DMO in C# - 11-07-2003 , 03:41 PM



In article <ef#Il9UpDHA.2528 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes
Quote:
Have a look at SQL NS
SQL-DMO has next to nothing to do with DTS.

http://www.sqldev.net/sqlns.htm
http://tinyurl.com/u36x
For the wizard your could also just shell out to dtswiz.exe.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org



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.