Prev: 3701 Errors after installing SP2
Next: SQLH2
From: d.s. on 7 Mar 2007 17:42
Here's the error I'm getting:

Cannot bulk load. Invalid column number in the format file "d:\comed
\ComEd Prospect Upload.fmt".
=================================================

Here's the format file I'm using. I can't figure it out:


8.0
95
1 SQLCHAR 0 255 "~" 1
ACCT SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 255 "~" 2
PREM SQL_Latin1_General_CP1_CI_AS
3 SQLCHAR 0 255 "~" 3
cUST SQL_Latin1_General_CP1_CI_AS
4 SQLCHAR 0 255 "~" 4
LSTNM SQL_Latin1_General_CP1_CI_AS
5 SQLCHAR 0 255 "~" 5
FRSTNM SQL_Latin1_General_CP1_CI_AS
6 SQLCHAR 0 255 "~" 6
MDLNM SQL_Latin1_General_CP1_CI_AS
7 SQLCHAR 0 255 "~" 7
TITL SQL_Latin1_General_CP1_CI_AS
8 SQLCHAR 0 255 "~" 8
name SQL_Latin1_General_CP1_CI_AS
9 SQLCHAR 0 255 "~" 9
m0 SQL_Latin1_General_CP1_CI_AS
10 SQLCHAR 0 255 "~" 10
[R C] SQL_Latin1_General_CP1_CI_AS
11 SQLCHAR 0 255 "~" 11
m1 SQL_Latin1_General_CP1_CI_AS
12 SQLCHAR 0 255 "~" 12
m2 SQL_Latin1_General_CP1_CI_AS
13 SQLCHAR 0 255 "~" 13
m3 SQL_Latin1_General_CP1_CI_AS
14 SQLCHAR 0 255 "~" 14
m4 SQL_Latin1_General_CP1_CI_AS
15 SQLCHAR 0 255 "~" 15
m5 SQL_Latin1_General_CP1_CI_AS
16 SQLCHAR 0 255 "~" 16
m6 SQL_Latin1_General_CP1_CI_AS
17 SQLCHAR 0 255 "~" 17
m7 SQL_Latin1_General_CP1_CI_AS
18 SQLCHAR 0 255 "~" 18
m8 SQL_Latin1_General_CP1_CI_AS
19 SQLCHAR 0 255 "~" 19
m9 SQL_Latin1_General_CP1_CI_AS
20 SQLCHAR 0 255 "~" 20
m10 SQL_Latin1_General_CP1_CI_AS
21 SQLCHAR 0 255 "~" 21
m11 SQL_Latin1_General_CP1_CI_AS
22 SQLCHAR 0 255 "~" 22
m12 SQL_Latin1_General_CP1_CI_AS
23 SQLCHAR 0 255 "~" 23
m13 SQL_Latin1_General_CP1_CI_AS
24 SQLCHAR 0 255 "~" 24
m14 SQL_Latin1_General_CP1_CI_AS
25 SQLCHAR 0 255 "~" 25
m15 SQL_Latin1_General_CP1_CI_AS
26 SQLCHAR 0 255 "~" 26
m16 SQL_Latin1_General_CP1_CI_AS
27 SQLCHAR 0 255 "~" 27
m17 SQL_Latin1_General_CP1_CI_AS
28 SQLCHAR 0 255 "~" 28
SERVAD SQL_Latin1_General_CP1_CI_AS
29 SQLCHAR 0 255 "~" 29
m18 SQL_Latin1_General_CP1_CI_AS
30 SQLCHAR 0 255 "~" 30
StrtNO SQL_Latin1_General_CP1_CI_AS
31 SQLCHAR 0 255 "~" 31
m19 SQL_Latin1_General_CP1_CI_AS
32 SQLCHAR 0 255 "~" 32
dirctn SQL_Latin1_General_CP1_CI_AS
33 SQLCHAR 0 255 "~" 33
strt SQL_Latin1_General_CP1_CI_AS
34 SQLCHAR 0 255 "~" 34
StrtSFX SQL_Latin1_General_CP1_CI_AS
35 SQLCHAR 0 255 "~" 35
postdir SQL_Latin1_General_CP1_CI_AS
36 SQLCHAR 0 255 "~" 36
m20 SQL_Latin1_General_CP1_CI_AS
37 SQLCHAR 0 255 "~" 37
Unt1 SQL_Latin1_General_CP1_CI_AS
38 SQLCHAR 0 255 "~" 38
Unt2 SQL_Latin1_General_CP1_CI_AS
39 SQLCHAR 0 255 "~" 39
CITY SQL_Latin1_General_CP1_CI_AS
40 SQLCHAR 0 255 "~" 40
ST SQL_Latin1_General_CP1_CI_AS
41 SQLCHAR 0 255 "~" 41
ZIP SQL_Latin1_General_CP1_CI_AS
42 SQLCHAR 0 255 "~" 42
M21 SQL_Latin1_General_CP1_CI_AS
43 SQLCHAR 0 255 "~" 43
M22 SQL_Latin1_General_CP1_CI_AS
44 SQLCHAR 0 255 "~" 44
AREA1 SQL_Latin1_General_CP1_CI_AS
45 SQLCHAR 0 255 "~" 45
PHNE1 SQL_Latin1_General_CP1_CI_AS
46 SQLCHAR 0 255 "~" 46
AREA2 SQL_Latin1_General_CP1_CI_AS
47 SQLCHAR 0 255 "~" 47
PHNE2 SQL_Latin1_General_CP1_CI_AS
48 SQLCHAR 0 255 "~" 48
EXT2 SQL_Latin1_General_CP1_CI_AS
49 SQLCHAR 0 255 "~" 49
M23 SQL_Latin1_General_CP1_CI_AS
50 SQLCHAR 0 255 "~" 50
M24 SQL_Latin1_General_CP1_CI_AS
51 SQLCHAR 0 255 "~" 51
M25 SQL_Latin1_General_CP1_CI_AS
52 SQLCHAR 0 255 "~" 52
M26 SQL_Latin1_General_CP1_CI_AS
53 SQLCHAR 0 255 "~" 53
M27 SQL_Latin1_General_CP1_CI_AS
54 SQLCHAR 0 255 "~" 54
RATE SQL_Latin1_General_CP1_CI_AS
55 SQLCHAR 0 255 "~" 55
M28 SQL_Latin1_General_CP1_CI_AS
56 SQLCHAR 0 255 "~" 56
M29 SQL_Latin1_General_CP1_CI_AS
57 SQLCHAR 0 255 "~" 57
M30 SQL_Latin1_General_CP1_CI_AS
58 SQLCHAR 0 255 "~" 58
mTRSEQ SQL_Latin1_General_CP1_CI_AS
59 SQLCHAR 0 255 "~" 59
MTR# SQL_Latin1_General_CP1_CI_AS
60 SQLCHAR 0 255 "~" 60
M31 SQL_Latin1_General_CP1_CI_AS
61 SQLCHAR 0 255 "~" 61
M32 SQL_Latin1_General_CP1_CI_AS
62 SQLCHAR 0 255 "~" 62
M33 SQL_Latin1_General_CP1_CI_AS
63 SQLCHAR 0 255 "~" 63
STAT SQL_Latin1_General_CP1_CI_AS
64 SQLCHAR 0 255 "~" 64
STATDT SQL_Latin1_General_CP1_CI_AS
65 SQLCHAR 0 255 "~" 65
ID SQL_Latin1_General_CP1_CI_AS
66 SQLCHAR 0 255 "~" 66
M34 SQL_Latin1_General_CP1_CI_AS
67 SQLCHAR 0 255 "~" 67
M35 SQL_Latin1_General_CP1_CI_AS
68 SQLCHAR 0 255 "~" 68
M36 SQL_Latin1_General_CP1_CI_AS
69 SQLCHAR 0 255 "~" 69
M37 SQL_Latin1_General_CP1_CI_AS
70 SQLCHAR 0 255 "~" 70
SLCIT SQL_Latin1_General_CP1_CI_AS
71 SQLCHAR 0 255 "~" 71
M38 SQL_Latin1_General_CP1_CI_AS
72 SQLCHAR 0 255 "~" 72
MUNI SQL_Latin1_General_CP1_CI_AS
73 SQLCHAR 0 255 "~" 73
M38A SQL_Latin1_General_CP1_CI_AS
74 SQLCHAR 0 255 "~" 74
M39 SQL_Latin1_General_CP1_CI_AS
75 SQLCHAR 0 255 "~" 75
M40 SQL_Latin1_General_CP1_CI_AS
76 SQLCHAR 0 255 "~" 76
M41 SQL_Latin1_General_CP1_CI_AS
77 SQLCHAR 0 255 "~" 77
M42 SQL_Latin1_General_CP1_CI_AS
78 SQLCHAR 0 255 "~" 78
M43 SQL_Latin1_General_CP1_CI_AS
79 SQLCHAR 0 255 "~" 79
M44 SQL_Latin1_General_CP1_CI_AS
80 SQLCHAR 0 255 "~" 80
M45 SQL_Latin1_General_CP1_CI_AS
81 SQLCHAR 0 255 "~" 81
M46 SQL_Latin1_General_CP1_CI_AS
82 SQLCHAR 0 255 "~" 82
M47 SQL_Latin1_General_CP1_CI_AS
83 SQLCHAR 0 255 "~" 83
BILGRP SQL_Latin1_General_CP1_CI_AS
84 SQLCHAR 0 255 "~" 84
RDR6 SQL_Latin1_General_CP1_CI_AS
85 SQLCHAR 0 255 "~" 85
RDR7 SQL_Latin1_General_CP1_CI_AS
86 SQLCHAR 0 255 "~" 86
sh SQL_Latin1_General_CP1_CI_AS
87 SQLCHAR 0 255 "~" 87
AC SQL_Latin1_General_CP1_CI_AS
88 SQLCHAR 0 255 "~" 88
M55 SQL_Latin1_General_CP1_CI_AS
89 SQLCHAR 0 255 "~" 89
BASEPL SQL_Latin1_General_CP1_CI_AS
90 SQLCHAR 0 255 "~" 90
pOSTC SQL_Latin1_General_CP1_CI_AS
91 SQLCHAR 0 255 "~" 91
rcrdr SQL_Latin1_General_CP1_CI_AS
92 SQLCHAR 0 255 "~" 92
cmo SQL_Latin1_General_CP1_CI_AS
93 SQLCHAR 0 255 "~" 93
MltyMtr SQL_Latin1_General_CP1_CI_AS
94 SQLCHAR 0 255 "~" 94
m60 SQL_Latin1_General_CP1_CI_AS
95 SQLCHAR 0 255 "\r\n"
95 m61 SQL_Latin1_General_CP1_CI_AS

 | 
Pages: 1
Prev: 3701 Errors after installing SP2
Next: SQLH2