DTS in MSDE2000

How export MSDE2000 database table in text file?
hi Viktor,
"Viktor Zadro" <viktor.zadro@.tel.net.ba> ha scritto nel messaggio
news:%23aWscynsEHA.2808@.TK2MSFTNGP14.phx.gbl
> How export MSDE2000 database table in text file?
you can use BCP (bulk copy program), available on MSDE intallations too...
it's a command line too and you can have a look for it's description at
http://msdn.microsoft.com/library/de...p_bcp_61et.asp
MSDE only provides the DTSRun command line utility and not the DTS designer,
so it can only run pre-packaged DTS packages...
http://msdn.microsoft.com/library/de...tsrun_95kp.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply