I have data in text file , delimited with Pipe and with help of DTS package
pump data to SQL server.

The issue is, the text file some rows can have 32 columns and some can be
33 columns and so on. Number of columns range from 32 - 40. How do i tell
DTS package (vbscript) to recognize the column number if it is not fixed ?

Can i specify in each row after 32 column, how extra columns i have ...
for example
32column | 2 | 50| 40

In above example after 32 column , next column says 2 which means i have
extra 2 column to pump data. Will this idea work ?

Any help gurus ?

Thanks,
Krish

It is not possible to do that just as it is not possible to have a table
with different number of columns per row.

I'd suggest to create a first row containing the maximum number of columns
so that the import interface will know the number of columns. If, during
import, following rows do not contain as much columns, I guess their value
will be NULL.

HTH,
Axel Dahmen


---------------------------
"Krish" <NOspam (AT) Nospam (DOT) org> schrieb im Newsbeitrag
news:e1HImMVMFHA.1172 (AT) TK2MSFTNGP12 (DOT) phx.gbl...