While using the SQLServer DTS package.
If I use Datapump to insert data from text file to table into a single
column will be faster or into a multiple columns will be faster.
If I insert data into single column, then I need to write a sql script or
procedure, use string operations to split the data again and insert them into
other columns of the table.

Example
Text file data
HTHIS IS A HEADER RECORD
DA20384000000983421DY
TTHIS IS A TRAILER RECORD

Inserting this into a single column of the table and then splitting the data
into four columns using procedure

Which one will be more optimized way usage.
--
Raja Voleti

If your data in the text file is delimited already then go with that from
the start. Performing the string operations after the DataPump will be
expensive.

Allan


"Raja Voleti" <RajaVoleti (AT) discussions (DOT) microsoft.com> wrote