Hi

I am wanting to to a bulk insert task in a DTS package.
This bulk insert must transfer data from a flat file that
has 27 columns delimited by the ~ sign into a table that
is only 7 columns. So i have to selectively choose the
columns i want using a format file. Until now i have not
gotten this correct. Does anyone have an example of a
format file for this process? The original 27 column
format file is below as well as my changed format file.
THANKS

ORIGNAL
7.0
27
1 SQLCHAR 0 100 "~" 1 c1
2 SQLCHAR 0 100 "~" 2 c2
3 SQLCHAR 0 100 "~" 3 c3
4 SQLCHAR 0 100 "~" 4 c4
5 SQLCHAR 0 100 "~" 5 c5
6 SQLCHAR 0 100 "~" 6 c6
7 SQLCHAR 0 100 "~" 7 c7
8 SQLCHAR 0 100 "~" 8 c8
9 SQLCHAR 0 100 "~" 9 c9
10 SQLCHAR 0 100 "~" 10 c10
11 SQLCHAR 0 100 "~" 11 c11
12 SQLCHAR 0 100 "~" 12 c12
13 SQLCHAR 0 100 "~" 13 c13
14 SQLCHAR 0 100 "~" 14 c14
15 SQLCHAR 0 100 "~" 15 c15
16 SQLCHAR 0 100 "~" 16 c16
17 SQLCHAR 0 100 "~" 17 c17
18 SQLCHAR 0 100 "~" 18 c18
19 SQLCHAR 0 100 "~" 19 c19
20 SQLCHAR 0 100 "~" 20 c20
21 SQLCHAR 0 100 "~" 21 c21
22 SQLCHAR 0 100 "~" 22 c22
23 SQLCHAR 0 100 "~" 23 c23
24 SQLCHAR 0 100 "~" 24 c24
25 SQLCHAR 0 100 "~" 25 c25
26 SQLCHAR 0 100 "~" 26 c26
27 SQLCHAR 0 100 "\r\n" 27 c27


CHANGED
7.0
27
1 SQLCHAR 0 100 "~" 1 c1
2 SQLCHAR 0 100 "~" 2 c2
3 SQLCHAR 0 100 "~" 3 c3
4 SQLCHAR 0 100 "~" 4 c4
5 SQLCHAR 0 100 "~" 5 c5
6 SQLCHAR 0 0 "" 0
7 SQLCHAR 0 0 "" 0
8 SQLCHAR 0 0 "" 0
9 SQLCHAR 0 0 "" 0
10 SQLCHAR 0 0 "" 0
11 SQLCHAR 0 0 "" 0
12 SQLCHAR 0 0 "" 0
13 SQLCHAR 0 100 "~" 13 c7
14 SQLCHAR 0 0 "" 0
15 SQLCHAR 0 0 "" 0
16 SQLCHAR 0 0 "" 0
17 SQLCHAR 0 0 "" 0
18 SQLCHAR 0 0 "" 0
19 SQLCHAR 0 0 "" 0
20 SQLCHAR 0 0 "" 0
21 SQLCHAR 0 0 "" 0
22 SQLCHAR 0 0 "" 0
23 SQLCHAR 0 0 "" 0
24 SQLCHAR 0 0 "" 0
25 SQLCHAR 0 0 "" 0
26 SQLCHAR 0 0 "" 0
27 SQLCHAR 0 100 "\r\n" 27 c7