Does any know how to use a DTS in conjunction with a format file to export
data to a text file? I know you can use a format file to import data with
DTS. I know that BCP can use a format file to export data, but the standard
is to use DTS packages for importing and exporting data.

Will this help you?

Bulk Export Task
(http://www.sqldts.com/default.aspx?237)



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Zach.Baier" <ZachBaier (AT) discussions (DOT) microsoft.com> wrote