Bulk insert via SQL DTS (follow up)

#1

Column delim = '~'
Row delim = #@#@#

Here is an example of the files being imported:

File 1:
1'~'Press Release#@#@#2'~'Original#@#@#3'~'Restated#@#@#4'~' No Change
from Original#@#@#5'~'Reclassified#@#@#

File 2:
5008378'~'336160'~'4'~'2003-08-24
00:00:00'~'2003'~'3'~'1'~'2004'~'2003-10-07
00:00:00'~'160'~'2'~'0#@#@#

File 3:
1'~'Annual Document'~'A#@#@#

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

Bulk insert via SQL DTS (follow up)

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

Bulk insert via SQL DTS (follow up) - 09-20-2004 , 08:48 AM