BCP to DTS format files

#1

I am trying to move some BCP commands to DTS and the
problem is that I don't know how to create a format file
in DTS similar to the one in BCP. The user of the data
still likes to see the field format in the text file. Any
ideas?

Thanks in advance,
Kim

#2

In article <042e01c3bf5b$7f17c820$a101280a (AT) phx (DOT) gbl>, Kim
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

I am trying to move some BCP commands to DTS and the
problem is that I don't know how to create a format file
in DTS similar to the one in BCP. The user of the data
still likes to see the field format in the text file. Any
ideas?

Thanks in advance,
Kim

If using the Bulk Insert Task then you can use the same format files as
used by BCP or the T-SQL BULK INSERT statement.

If using the DataPump then there is no need for a format file.

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

BCP to DTS format files

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

BCP to DTS format files - 12-10-2003 , 02:23 PM

Re: BCP to DTS format files - 12-10-2003 , 03:11 PM