Groups | Blog | Home
all groups > sql server dts > november 2003 >

sql server dts : Call DTS with SQL DMO in C#


hrhoe
11/7/2003 8:22:19 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?

Allan Mitchell
11/7/2003 4:52:23 PM
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

[quoted text, click to view]

Darren Green
11/7/2003 9:41:26 PM
In article <ef#Il9UpDHA.2528@TK2MSFTNGP10.phx.gbl>, Allan Mitchell
<allan@no-spam.sqldts.com> writes
[quoted text, click to view]

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
AddThis Social Bookmark Button