Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Bulk Insert

Author  Topic 

starnold
Yak Posting Veteran

83 Posts
Posted - 2006-05-15 : 10:52:28
Please can you help. We are trying to import a fixed length text file using Bulk Insert and keep getting the error, Invalid Column number in format file.

Any help please an example of the format file is below:

8.0
479
1 SQLCHAR 0 12 "" 1 [BMS_ID] Latin1_General_CI_AS NULL
2 SQLCHAR 0 9 "" 2 [DUNS] Latin1_General_CI_AS NULL
3 SQLCHAR 0 8 "" 3 [8_DIG_SIC] Latin1_General_CI_AS NULL
4 SQLCHAR 0 4 "" 4 [Filler] Latin1_General_CI_AS NULL
5 SQLCHAR 0 90 "" 5 [CO_NAME] Latin1_General_CI_AS NULL
6 SQLCHAR 0 90 "" 6 [Former_Name] Latin1_General_CI_AS NULL
7 SQLCHAR 0 64 "" 7 [Trading_Style_1] Latin1_General_CI_AS NULL
8 SQLCHAR 0 64 "" 8 [Trading_Style_2] Latin1_General_CI_AS NULL
9 SQLCHAR 0 64 "" 9 [Trading_Style_3] Latin1_General_CI_AS NULL
10 SQLCHAR 0 64 "" 10 [Trading_Style_4] Latin1_General_CI_AS NULL
11 SQLCHAR 0 40 "" 11 [STREET1] Latin1_General_CI_AS NULL
12 SQLCHAR 0 40 "" 12 [STREET2] Latin1_General_CI_AS NULL
13 SQLCHAR 0 40 "" 13 [STREET3] Latin1_General_CI_AS NULL
14 SQLCHAR 0 40 "" 14 [STREET4] Latin1_General_CI_AS NULL
15 SQLCHAR 0 25 "" 15 [TOWN] Latin1_General_CI_AS NULL
16 SQLCHAR 0 20 "" 17 [COUNTY] Latin1_General_CI_AS NULL
17 SQLCHAR 0 20 "" 18 [Index_County] Latin1_General_CI_AS NULL
18 SQLCHAR 0 8 "" 19 [PCODE] Latin1_General_CI_AS NULL
19 SQLCHAR 0 9 "" 20 [Index_Postcode] Latin1_General_CI_AS NULL
20 SQLCHAR 0 2 "" 21 [ECON_REG] Latin1_General_CI_AS NULL
21 SQLCHAR 0 3 "" 22 [SECTOR_CDE] Latin1_General_CI_AS NULL
22 SQLCHAR 0 1 "" 23 [Country_Code] Latin1_General_CI_AS NULL
23 SQLCHAR 0 14 "" 24 [TEL_NBR] Latin1_General_CI_AS NULL
24 SQLCHAR 0 14 "" 26 [FAX_NBR] Latin1_General_CI_AS NULL
25 SQLCHAR 0 11 "" 28 [CRO_NBR] Latin1_General_CI_AS NULL
26 SQLCHAR 0 9 "" 29 [VAT_NBR] Latin1_General_CI_AS NULL
27 SQLCHAR 0 5 "" 30 [PF_Code] Latin1_General_CI_AS NULL
28 SQLCHAR 0 128 "" 31 [LOB_DESC] Latin1_General_CI_AS NULL
29 SQLCHAR 0 4 "" 32 [US72_SIC1] Latin1_General_CI_AS NULL
30 SQLCHAR 0 4 "" 33 [US72_SIC2] Latin1_General_CI_AS NULL
31 SQLCHAR 0 4 "" 34 [US72_SIC3] Latin1_General_CI_AS NULL
32 SQLCHAR 0 4 "" 35 [US72_SIC4] Latin1_General_CI_AS NULL
33 SQLCHAR 0 4 "" 36 [US72_SIC5] Latin1_General_CI_AS NULL
34 SQLCHAR 0 4 "" 37 [US72_SIC6] Latin1_General_CI_AS NULL
35 SQLCHAR 0 4 "" 38 [US87_SIC1] Latin1_General_CI_AS NULL
36 SQLCHAR 0 4 "" 39 [US87_SIC2] Latin1_General_CI_AS NULL
37 SQLCHAR 0 4 "" 40 [US87_SIC3] Latin1_General_CI_AS NULL
38 SQLCHAR 0 4 "" 41 [US87_SIC4] Latin1_General_CI_AS NULL
39 SQLCHAR 0 4 "" 42 [US87_SIC5] Latin1_General_CI_AS NULL
40 SQLCHAR 0 4 "" 43 [US87_SIC6] Latin1_General_CI_AS NULL
41 SQLCHAR 0 5 "" 44 [UK80_SIC1] Latin1_General_CI_AS NULL
42 SQLCHAR 0 5 "" 45 [UK80_SIC2] Latin1_General_CI_AS NULL
43 SQLCHAR 0 5 "" 46 [UK80_SIC3] Latin1_General_CI_AS NULL
44 SQLCHAR 0 5 "" 47 [UK80_SIC4] Latin1_General_CI_AS NULL
45 SQLCHAR 0 5 "" 48 [UK80_SIC5] Latin1_General_CI_AS NULL
46 SQLCHAR 0 5 "" 49 [UK80_SIC6] Latin1_General_CI_AS NULL
47 SQLCHAR 0 6 "" 50 [UK92_SIC1] Latin1_General_CI_AS NULL
48 SQLCHAR 0 6 "" 51 [UK92_SIC2] Latin1_General_CI_AS NULL
49 SQLCHAR 0 6 "" 52 [UK92_SIC3] Latin1_General_CI_AS NULL
50 SQLCHAR 0 6 "" 53 [UK92_SIC4] Latin1_General_CI_AS NULL
51 SQLCHAR 0 6 "" 54 [UK92_SIC5] Latin1_General_CI_AS NULL
52 SQLCHAR 0 6 "" 55 [UK92_SIC6] Latin1_General_CI_AS NULL
53 SQLCHAR 0 5 "" 56 [NACE_(1)] Latin1_General_CI_AS NULL
54 SQLCHAR 0 5 "" 57 [NACE_(2)] Latin1_General_CI_AS NULL
55 SQLCHAR 0 5 "" 58 [NACE_(3)] Latin1_General_CI_AS NULL
56 SQLCHAR 0 5 "" 59 [NACE_(4)] Latin1_General_CI_AS NULL
57 SQLCHAR 0 5 "" 60 [NACE_(5)] Latin1_General_CI_AS NULL
58 SQLCHAR 0 5 "" 61 [NACE_(6)] Latin1_General_CI_AS NULL
59 SQLCHAR 0 3 "" 62 [Bank_of_England_Class] Latin1_General_CI_AS NULL
60 SQLCHAR 0 2 "" 63 [LEGAL_CDE] Latin1_General_CI_AS NULL
61 SQLCHAR 0 6 "" 64 [New_Relocated_Date] Latin1_General_CI_AS NULL
62 SQLCHAR 0 1 "" 65 [New_Relocated_Ind] Latin1_General_CI_AS NULL
63 SQLCHAR 0 4 "" 66 [YR_START] Latin1_General_CI_AS NULL
64 SQLCHAR 0 6 "" 67 [UPD_DATE] Latin1_General_CI_AS NULL
65 SQLCHAR 0 9 "" 68 [EMPS_COMP] Latin1_General_CI_AS NULL
66 SQLCHAR 0 9 "" 69 [EMPS_SITE] Latin1_General_CI_AS NULL
67 SQLCHAR 0 15 "" 70 [ALGOSALE] Latin1_General_CI_AS NULL
68 SQLCHAR 0 15 "" 71 [Sales] Latin1_General_CI_AS NULL
69 SQLCHAR 0 6 "" 72 [FIN_YREND] Latin1_General_CI_AS NULL
70 SQLCHAR 0 15 "" 73 [Profit] Latin1_General_CI_AS NULL
71 SQLCHAR 0 1 "" 74 [PROFIT_IND] Latin1_General_CI_AS NULL
72 SQLCHAR 0 15 "" 75 [PROFIT_AMT] Latin1_General_CI_AS NULL
73 SQLCHAR 0 5 "" 76 [PROFIT_PCT] Latin1_General_CI_AS NULL
74 SQLCHAR 0 1 "" 77 [SALES_IND] Latin1_General_CI_AS NULL
75 SQLCHAR 0 15 "" 78 [SALES_AMT] Latin1_General_CI_AS NULL
76 SQLCHAR 0 5 "" 79 [SALES_PCT] Latin1_General_CI_AS NULL
77 SQLCHAR 0 15 "" 80 [NETWORTH] Latin1_General_CI_AS NULL
78 SQLCHAR 0 15 "" 81 [FIX_ASSETS] Latin1_General_CI_AS NULL
79 SQLCHAR 0 15 "" 82 [TOT_ASSETS] Latin1_General_CI_AS NULL
80 SQLCHAR 0 15 "" 83 [CUR_ASSETS] Latin1_General_CI_AS NULL
81 SQLCHAR 0 15 "" 84 [CUR_LIABS] Latin1_General_CI_AS NULL
82 SQLCHAR 0 15 "" 85 [WORK_CAP] Latin1_General_CI_AS NULL
83 SQLCHAR 0 15 "" 86 [LTERM_DEBT] Latin1_General_CI_AS NULL
84 SQLCHAR 0 15 "" 87 [Debtors] Latin1_General_CI_AS NULL
85 SQLCHAR 0 15 "" 88 [CUR_RATIO] Latin1_General_CI_AS NULL
86 SQLCHAR 0 15 "" 89 [GEAR_RATIO] Latin1_General_CI_AS NULL
87 SQLCHAR 0 3 "" 90 [RatingNW] Latin1_General_CI_AS NULL
88 SQLCHAR 0 1 "" 91 [RatingCC] Latin1_General_CI_AS NULL
89 SQLCHAR 0 9 "" 92 [MAX_CREDIT] Latin1_General_CI_AS NULL
90 SQLCHAR 0 3 "" 93 [PAY_SCORE] Latin1_General_CI_AS NULL
91 SQLCHAR 0 1 "" 94 [IMPEXP_ID] Latin1_General_CI_AS NULL
92 SQLCHAR 0 160 "" 95 [Bankers] Latin1_General_CI_AS NULL
93 SQLCHAR 0 6 "" 96 [BANK_CODE] Latin1_General_CI_AS NULL
94 SQLCHAR 0 100 "" 97 [AUDITORS] Latin1_General_CI_AS NULL
95 SQLCHAR 0 1 "" 98 [LOC_IND] Latin1_General_CI_AS NULL
96 SQLCHAR 0 5 "" 99 [BRANCHES] Latin1_General_CI_AS NULL
97 SQLCHAR 0 12 "" 100 [HQ_ID] Latin1_General_CI_AS NULL
98 SQLCHAR 0 9 "" 101 [HQ_DUNS] Latin1_General_CI_AS NULL
99 SQLCHAR 0 90 "" 102 [HQ_NAME] Latin1_General_CI_AS NULL
100 SQLCHAR 0 25 "" 103 [HQ_Town] Latin1_General_CI_AS NULL
101 SQLCHAR 0 12 "" 104 [Immediate_Parent_ID] Latin1_General_CI_AS NULL
102 SQLCHAR 0 9 "" 105 [IMM_DUNS] Latin1_General_CI_AS NULL
103 SQLCHAR 0 50 "" 106 [IMM_NAME] Latin1_General_CI_AS NULL
104 SQLCHAR 0 50 "" 107 [ULTUK_NAME] Latin1_General_CI_AS NULL
105 SQLCHAR 0 9 "" 108 [ULTUK_DUNS] Latin1_General_CI_AS NULL
106 SQLCHAR 0 12 "" 109 [Ultimate_Parent_ID] Latin1_General_CI_AS NULL
107 SQLCHAR 0 9 "" 110 [ULT_DUNS] Latin1_General_CI_AS NULL
108 SQLCHAR 0 50 "" 111 [ULT_NAME] Latin1_General_CI_AS NULL
109 SQLCHAR 0 3 "" 112 [ULT_CTRY] Latin1_General_CI_AS NULL
110 SQLCHAR 0 2 "" 113 [Ultimate_Parent_Continent] Latin1_General_CI_AS NULL
111 SQLCHAR 0 3 "" 114 [UK_SUBS] Latin1_General_CI_AS NULL
112 SQLCHAR 0 3 "" 115 [Foreign_Subsidiaries_(1)] Latin1_General_CI_AS NULL
113 SQLCHAR 0 3 "" 116 [Foreign_Subsidiaries_(2)] Latin1_General_CI_AS NULL
114 SQLCHAR 0 3 "" 117 [Foreign_Subsidiaries_(3)] Latin1_General_CI_AS NULL
115 SQLCHAR 0 3 "" 118 [Foreign_Subsidiaries_(4)] Latin1_General_CI_AS NULL
116 SQLCHAR 0 3 "" 119 [Foreign_Subsidiaries_(5)] Latin1_General_CI_AS NULL
117 SQLCHAR 0 3 "" 120 [Foreign_Subsidiaries_(6)] Latin1_General_CI_AS NULL
118 SQLCHAR 0 3 "" 121 [Foreign_Subsidiaries_(7)] Latin1_General_CI_AS NULL
119 SQLCHAR 0 3 "" 122 [Foreign_Subsidiaries_(8)] Latin1_General_CI_AS NULL
120 SQLCHAR 0 3 "" 123 [Foreign_Subsidiaries_(9)] Latin1_General_CI_AS NULL
121 SQLCHAR 0 3 "" 124 [Foreign_Subsidiaries_(10)] Latin1_General_CI_AS NULL
122 SQLCHAR 0 3 "" 125 [Foreign_Subsidiaries_(11)] Latin1_General_CI_AS NULL
123 SQLCHAR 0 3 "" 126 [Foreign_Subsidiaries_(12)] Latin1_General_CI_AS NULL
124 SQLCHAR 0 3 "" 127 [Foreign_Subsidiaries_(13)] Latin1_General_CI_AS NULL
125 SQLCHAR 0 3 "" 128 [Foreign_Subsidiaries_(14)] Latin1_General_CI_AS NULL
126 SQLCHAR 0 3 "" 129 [Foreign_Subsidiaries_(15)] Latin1_General_CI_AS NULL
127 SQLCHAR 0 3 "" 130 [Foreign_Subsidiaries_(16)] Latin1_General_CI_AS NULL
128 SQLCHAR 0 3 "" 131 [Foreign_Subsidiaries_(17)] Latin1_General_CI_AS NULL
129 SQLCHAR 0 3 "" 132 [Foreign_Subsidiaries_(18)] Latin1_General_CI_AS NULL
130 SQLCHAR 0 3 "" 133 [Foreign_Subsidiaries_(19)] Latin1_General_CI_AS NULL
131 SQLCHAR 0 3 "" 134 [Foreign_Subsidiaries_(20)] Latin1_General_CI_AS NULL
132 SQLCHAR 0 3 "" 135 [Foreign_Subsidiaries_(21)] Latin1_General_CI_AS NULL
133 SQLCHAR 0 3 "" 136 [Foreign_Subsidiaries_(22)] Latin1_General_CI_AS NULL
134 SQLCHAR 0 3 "" 137 [Foreign_Subsidiaries_(23)] Latin1_General_CI_AS NULL
135 SQLCHAR 0 3 "" 138 [Foreign_Subsidiaries_(24)] Latin1_General_CI_AS NULL
136 SQLCHAR 0 3 "" 139 [Foreign_Subsidiaries_(25)] Latin1_General_CI_AS NULL
137 SQLCHAR 0 3 "" 140 [Foreign_Subsidiaries_(26)] Latin1_General_CI_AS NULL
138 SQLCHAR 0 3 "" 141 [Foreign_Subsidiaries_(27)] Latin1_General_CI_AS NULL
139 SQLCHAR 0 3 "" 142 [Foreign_Subsidiaries_(28)] Latin1_General_CI_AS NULL
140 SQLCHAR 0 3 "" 143 [Foreign_Subsidiaries_(29)] Latin1_General_CI_AS NULL
141 SQLCHAR 0 3 "" 144 [Foreign_Subsidiaries_(30)] Latin1_General_CI_AS NULL
142 SQLCHAR 0 3 "" 145 [Foreign_Subsidiaries_(31)] Latin1_General_CI_AS NULL
143 SQLCHAR 0 3 "" 146 [Foreign_Subsidiaries_(32)] Latin1_General_CI_AS NULL
144 SQLCHAR 0 3 "" 147 [Foreign_Subsidiaries_(33)] Latin1_General_CI_AS NULL
145 SQLCHAR 0 3 "" 148 [Foreign_Subsidiaries_(34)] Latin1_General_CI_AS NULL
146 SQLCHAR 0 3 "" 149 [Foreign_Subsidiaries_(35)] Latin1_General_CI_AS NULL
147 SQLCHAR 0 3 "" 150 [Foreign_Subsidiaries_(36)] Latin1_General_CI_AS NULL
148 SQLCHAR 0 3 "" 151 [Foreign_Subsidiaries_(37)] Latin1_General_CI_AS NULL
149 SQLCHAR 0 3 "" 152 [Foreign_Subsidiaries_(38)] Latin1_General_CI_AS NULL
150 SQLCHAR 0 3 "" 153 [Foreign_Subsidiaries_(39)] Latin1_General_CI_AS NULL
151 SQLCHAR 0 3 "" 154 [Foreign_Subsidiaries_(40)] Latin1_General_CI_AS NULL
152 SQLCHAR 0 3 "" 155 [Foreign_Subsidiaries_(41)] Latin1_General_CI_AS NULL
153 SQLCHAR 0 3 "" 156 [Foreign_Subsidiaries_(42)] Latin1_General_CI_AS NULL
154 SQLCHAR 0 3 "" 157 [Foreign_Subsidiaries_(43)] Latin1_General_CI_AS NULL
155 SQLCHAR 0 3 "" 158 [Foreign_Subsidiaries_(44)] Latin1_General_CI_AS NULL
156 SQLCHAR 0 3 "" 159 [Foreign_Subsidiaries_(45)] Latin1_General_CI_AS NULL
157 SQLCHAR 0 3 "" 160 [Foreign_Subsidiaries_(46)] Latin1_General_CI_AS NULL
158 SQLCHAR 0 3 "" 161 [Foreign_Subsidiaries_(47)] Latin1_General_CI_AS NULL
159 SQLCHAR 0 3 "" 162 [Foreign_Subsidiaries_(48)] Latin1_General_CI_AS NULL
160 SQLCHAR 0 3 "" 163 [Foreign_Subsidiaries_(49)] Latin1_General_CI_AS NULL
161 SQLCHAR 0 3 "" 164 [Foreign_Subsidiaries_(50)] Latin1_General_CI_AS NULL
162 SQLCHAR 0 2 "" 165 [Foreign_Subs_Continent(1)] Latin1_General_CI_AS NULL
163 SQLCHAR 0 2 "" 166 [Foreign_Subs_Continent(2)] Latin1_General_CI_AS NULL
164 SQLCHAR 0 2 "" 167 [Foreign_Subs_Continent(3)] Latin1_General_CI_AS NULL
165 SQLCHAR 0 2 "" 168 [Foreign_Subs_Continent(4)] Latin1_General_CI_AS NULL
166 SQLCHAR 0 2 "" 169 [Foreign_Subs_Continent(5)] Latin1_General_CI_AS NULL
167 SQLCHAR 0 2 "" 170 [Foreign_Subs_Continent(6)] Latin1_General_CI_AS NULL
168 SQLCHAR 0 2 "" 171 [Foreign_Subs_Continent(7)] Latin1_General_CI_AS NULL
169 SQLCHAR 0 2 "" 172 [Foreign_Subs_Continent(8)] Latin1_General_CI_AS NULL
170 SQLCHAR 0 2 "" 173 [Foreign_Subs_Continent(9)] Latin1_General_CI_AS NULL
171 SQLCHAR 0 2 "" 174 [Foreign_Subs_Continent(10)] Latin1_General_CI_AS NULL
172 SQLCHAR 0 2 "" 175 [EXEC_CD1] Latin1_General_CI_AS NULL
173 SQLCHAR 0 32 "" 183 [EXEC_FNAM1] Latin1_General_CI_AS NULL
174 SQLCHAR 0 32 "" 184 [EXEC_SNAM1] Latin1_General_CI_AS NULL
175 SQLCHAR 0 40 "" 185 [EXEC_FUNC1] Latin1_General_CI_AS NULL
176 SQLCHAR 0 40 "" 186 [EXEC_SAL1] Latin1_General_CI_AS NULL
177 SQLCHAR 0 1 "" 187 [EXEC_SEX1] Latin1_General_CI_AS NULL
178 SQLCHAR 0 11 "" 188 [EXEC_PID1] Latin1_General_CI_AS NULL
179 SQLCHAR 0 1 "" 189 [Fin_Resp_Code(1)] Latin1_General_CI_AS NULL
180 SQLCHAR 0 1 "" 190 [Mrk_Resp_Code(1)] Latin1_General_CI_AS NULL
181 SQLCHAR 0 1 "" 191 [HR_Resp_Code(1)] Latin1_General_CI_AS NULL
182 SQLCHAR 0 1 "" 192 [TR_Resp_Code(1)] Latin1_General_CI_AS NULL
183 SQLCHAR 0 1 "" 193 [IT_Mngt_Resp_Code(1)] Latin1_General_CI_AS NULL
184 SQLCHAR 0 1 "" 194 [Fleet_Mngt_Resp_Code(1)] Latin1_General_CI_AS NULL
185 SQLCHAR 0 1 "" 195 [Fac_Mngt_Resp_Cd(1)] Latin1_General_CI_AS NULL
186 SQLCHAR 0 2 "" 176 [EXEC_CD2] Latin1_General_CI_AS NULL
187 SQLCHAR 0 32 "" 196 [EXEC_FNAM2] Latin1_General_CI_AS NULL
188 SQLCHAR 0 32 "" 197 [EXEC_SNAM2] Latin1_General_CI_AS NULL
189 SQLCHAR 0 40 "" 198 [EXEC_FUNC2] Latin1_General_CI_AS NULL
190 SQLCHAR 0 40 "" 199 [EXEC_SAL2] Latin1_General_CI_AS NULL
191 SQLCHAR 0 1 "" 200 [EXEC_SEX2] Latin1_General_CI_AS NULL
192 SQLCHAR 0 11 "" 201 [EXEC_PID2] Latin1_General_CI_AS NULL
193 SQLCHAR 0 1 "" 202 [Fin_Resp_Code(2)] Latin1_General_CI_AS NULL
194 SQLCHAR 0 1 "" 203 [Mrk_Resp_Code(2)] Latin1_General_CI_AS NULL
195 SQLCHAR 0 1 "" 204 [HR_Resp_Code(2)] Latin1_General_CI_AS NULL
196 SQLCHAR 0 1 "" 205 [TR_Resp_Code(2)] Latin1_General_CI_AS NULL
197 SQLCHAR 0 1 "" 206 [IT_Mngt_Resp_Code(2)] Latin1_General_CI_AS NULL
198 SQLCHAR 0 1 "" 207 [Fleet_Mngt_Resp_Code(2)] Latin1_General_CI_AS NULL
199 SQLCHAR 0 1 "" 208 [Fac_Mngt_Resp_Cd(2)] Latin1_General_CI_AS NULL
200 SQLCHAR 0 2 "" 177 [EXEC_CD3] Latin1_General_CI_AS NULL
201 SQLCHAR 0 32 "" 209 [EXEC_FNAM3] Latin1_General_CI_AS NULL
202 SQLCHAR 0 32 "" 210 [EXEC_SNAM3] Latin1_General_CI_AS NULL
203 SQLCHAR 0 40 "" 211 [EXEC_FUNC3] Latin1_General_CI_AS NULL
204 SQLCHAR 0 40 "" 212 [EXEC_SAL3] Latin1_General_CI_AS NULL
205 SQLCHAR 0 1 "" 213 [EXEC_SEX3] Latin1_General_CI_AS NULL
206 SQLCHAR 0 11 "" 214 [EXEC_PID3] Latin1_General_CI_AS NULL
207 SQLCHAR 0 1 "" 215 [Fin_Resp_Code(3)] Latin1_General_CI_AS NULL
208 SQLCHAR 0 1 "" 216 [Mrk_Resp_Code(3)] Latin1_General_CI_AS NULL
209 SQLCHAR 0 1 "" 217 [HR_Resp_Code(3)] Latin1_General_CI_AS NULL
210 SQLCHAR 0 1 "" 218 [TR_Resp_Code(3)] Latin1_General_CI_AS NULL
211 SQLCHAR 0 1 "" 219 [IT_Mngt_Resp_Code(3)] Latin1_General_CI_AS NULL
212 SQLCHAR 0 1 "" 220 [Fleet_Mngt_Resp_Code(3)] Latin1_General_CI_AS NULL
213 SQLCHAR 0 1 "" 221 [Fac_Mngt_Resp_Cd(3)] Latin1_General_CI_AS NULL
214 SQLCHAR 0 2 "" 178 [EXEC_CD4] Latin1_General_CI_AS NULL
215 SQLCHAR 0 32 "" 222 [EXEC_FNAM4] Latin1_General_CI_AS NULL
216 SQLCHAR 0 32 "" 223 [EXEC_SNAM4] Latin1_General_CI_AS NULL
217 SQLCHAR 0 40 "" 224 [EXEC_FUNC4] Latin1_General_CI_AS NULL
218 SQLCHAR 0 40 "" 225 [EXEC_SAL4] Latin1_General_CI_AS NULL
219 SQLCHAR 0 1 "" 226 [EXEC_SEX4] Latin1_General_CI_AS NULL
220 SQLCHAR 0 11 "" 227 [EXEC_PID4] Latin1_General_CI_AS NULL
221 SQLCHAR 0 1 "" 228 [Fin_Resp_Code(4)] Latin1_General_CI_AS NULL
222 SQLCHAR 0 1 "" 229 [Mrk_Resp_Code(4)] Latin1_General_CI_AS NULL
223 SQLCHAR 0 1 "" 230 [HR_Resp_Code(4)] Latin1_General_CI_AS NULL
224 SQLCHAR 0 1 "" 231 [TR_Resp_Code(4)] Latin1_General_CI_AS NULL
225 SQLCHAR 0 1 "" 232 [IT_Mngt_Resp_Code(4)] Latin1_General_CI_AS NULL
226 SQLCHAR 0 1 "" 233 [Fleet_Mngt_Resp_Code(4)] Latin1_General_CI_AS NULL
227 SQLCHAR 0 1 "" 234 [Fac_Mngt_Resp_Cd(4)] Latin1_General_CI_AS NULL
228 SQLCHAR 0 2 "" 179 [EXEC_CD5] Latin1_General_CI_AS NULL
229 SQLCHAR 0 32 "" 235 [EXEC_FNAM5] Latin1_General_CI_AS NULL
230 SQLCHAR 0 32 "" 236 [EXEC_SNAM5] Latin1_General_CI_AS NULL
231 SQLCHAR 0 40 "" 237 [EXEC_FUNC5] Latin1_General_CI_AS NULL
232 SQLCHAR 0 40 "" 238 [EXEC_SAL5] Latin1_General_CI_AS NULL
233 SQLCHAR 0 1 "" 239 [EXEC_SEX5] Latin1_General_CI_AS NULL
234 SQLCHAR 0 11 "" 240 [EXEC_PID5] Latin1_General_CI_AS NULL
235 SQLCHAR 0 1 "" 241 [Fin_Resp_Code(5)] Latin1_General_CI_AS NULL
236 SQLCHAR 0 1 "" 242 [Mrk_Resp_Code(5)] Latin1_General_CI_AS NULL
237 SQLCHAR 0 1 "" 243 [HR_Resp_Code(5)] Latin1_General_CI_AS NULL
238 SQLCHAR 0 1 "" 244 [TR_Resp_Code(5)] Latin1_General_CI_AS NULL
239 SQLCHAR 0 1 "" 245 [IT_Mngt_Resp_Code(5)] Latin1_General_CI_AS NULL
240 SQLCHAR 0 1 "" 246 [Fleet_Mngt_Resp_Code(5)] Latin1_General_CI_AS NULL
241 SQLCHAR 0 1 "" 247 [Fac_Mngt_Resp_Cd(5)] Latin1_General_CI_AS NULL
242 SQLCHAR 0 2 "" 180 [EXEC_CD6] Latin1_General_CI_AS NULL
243 SQLCHAR 0 32 "" 248 [EXEC_FNAM6] Latin1_General_CI_AS NULL
244 SQLCHAR 0 32 "" 249 [EXEC_SNAM6] Latin1_General_CI_AS NULL
245 SQLCHAR 0 40 "" 250 [EXEC_FUNC6] Latin1_General_CI_AS NULL
246 SQLCHAR 0 40 "" 251 [EXEC_SAL6] Latin1_General_CI_AS NULL
247 SQLCHAR 0 1 "" 252 [EXEC_SEX6] Latin1_General_CI_AS NULL
248 SQLCHAR 0 11 "" 253 [EXEC_PID6] Latin1_General_CI_AS NULL
249 SQLCHAR 0 1 "" 254 [Fin_Resp_Code(6)] Latin1_General_CI_AS NULL
250 SQLCHAR 0 1 "" 255 [Mrk_Resp_Code(6)] Latin1_General_CI_AS NULL
251 SQLCHAR 0 1 "" 256 [HR_Resp_Code(6)] Latin1_General_CI_AS NULL
252 SQLCHAR 0 1 "" 257 [TR_Resp_Code(6)] Latin1_General_CI_AS NULL
253 SQLCHAR 0 1 "" 258 [IT_Mngt_Resp_Code(6)] Latin1_General_CI_AS NULL
254 SQLCHAR 0 1 "" 259 [Fleet_Mngt_Resp_Code(6)] Latin1_General_CI_AS NULL
255 SQLCHAR 0 1 "" 260 [Fac_Mngt_Resp_Cd(6)] Latin1_General_CI_AS NULL
256 SQLCHAR 0 2 "" 181 [EXEC_CD7] Latin1_General_CI_AS NULL
257 SQLCHAR 0 32 "" 261 [EXEC_FNAM7] Latin1_General_CI_AS NULL
258 SQLCHAR 0 32 "" 262 [EXEC_SNAM7] Latin1_General_CI_AS NULL
259 SQLCHAR 0 40 "" 263 [EXEC_FUNC7] Latin1_General_CI_AS NULL
260 SQLCHAR 0 40 "" 264 [EXEC_SAL7] Latin1_General_CI_AS NULL
261 SQLCHAR 0 1 "" 265 [EXEC_SEX7] Latin1_General_CI_AS NULL
262 SQLCHAR 0 11 "" 266 [EXEC_PID7] Latin1_General_CI_AS NULL
263 SQLCHAR 0 1 "" 267 [Fin_Resp_Code(7)] Latin1_General_CI_AS NULL
264 SQLCHAR 0 1 "" 268 [Mrk_Resp_Code(7)] Latin1_General_CI_AS NULL
265 SQLCHAR 0 1 "" 269 [HR_Resp_Code(7)] Latin1_General_CI_AS NULL
266 SQLCHAR 0 1 "" 270 [TR_Resp_Code(7)] Latin1_General_CI_AS NULL
267 SQLCHAR 0 1 "" 271 [IT_Mngt_Resp_Code(7)] Latin1_General_CI_AS NULL
268 SQLCHAR 0 1 "" 272 [Fleet_Mngt_Resp_Code(7)] Latin1_General_CI_AS NULL
269 SQLCHAR 0 1 "" 273 [Fac_Mngt_Resp_Cd(7)] Latin1_General_CI_AS NULL
270 SQLCHAR 0 2 "" 182 [EXEC_CD8] Latin1_General_CI_AS NULL
271 SQLCHAR 0 32 "" 274 [EXEC_FNAM8] Latin1_General_CI_AS NULL
272 SQLCHAR 0 32 "" 275 [EXEC_SNAM8] Latin1_General_CI_AS NULL
273 SQLCHAR 0 40 "" 276 [EXEC_FUNC8] Latin1_General_CI_AS NULL
274 SQLCHAR 0 40 "" 277 [EXEC_SAL8] Latin1_General_CI_AS NULL
275 SQLCHAR 0 1 "" 278 [EXEC_SEX8] Latin1_General_CI_AS NULL
276 SQLCHAR 0 11 "" 279 [EXEC_PID8] Latin1_General_CI_AS NULL
277 SQLCHAR 0 1 "" 280 [Fin_Resp_Code(8)] Latin1_General_CI_AS NULL
278 SQLCHAR 0 1 "" 281 [Mrk_Resp_Code(8)] Latin1_General_CI_AS NULL
279 SQLCHAR 0 1 "" 282 [HR_Resp_Code(8)] Latin1_General_CI_AS NULL
280 SQLCHAR 0 1 "" 283 [TR_Resp_Code(8)] Latin1_General_CI_AS NULL
281 SQLCHAR 0 1 "" 284 [IT_Mngt_Resp_Code(8)] Latin1_General_CI_AS NULL
282 SQLCHAR 0 1 "" 285 [Fleet_Mngt_Resp_Code(8)] Latin1_General_CI_AS NULL
283 SQLCHAR 0 1 "" 286 [Fac_Mngt_Resp_Cd(8)] Latin1_General_CI_AS NULL
284 SQLCHAR 0 2 "" 289 [EMS_Codes(FN)] Latin1_General_CI_AS NULL
285 SQLCHAR 0 32 "" 290 [FIN_FNAME] Latin1_General_CI_AS NULL
286 SQLCHAR 0 32 "" 291 [FIN_SNAME] Latin1_General_CI_AS NULL
287 SQLCHAR 0 40 "" 292 [FIN_FUNC] Latin1_General_CI_AS NULL
288 SQLCHAR 0 40 "" 293 [FIN_SAL] Latin1_General_CI_AS NULL
289 SQLCHAR 0 1 "" 294 [FIN_SEX] Latin1_General_CI_AS NULL
290 SQLCHAR 0 11 "" 295 [Person_ID(FN)] Latin1_General_CI_AS NULL
291 SQLCHAR 0 1 "" 296 [Fin_Resp_Code(FN)] Latin1_General_CI_AS NULL
292 SQLCHAR 0 1 "" 297 [Mrk_Resp_Code(FN)] Latin1_General_CI_AS NULL
293 SQLCHAR 0 1 "" 298 [HR_Resp_Code(FN)] Latin1_General_CI_AS NULL
294 SQLCHAR 0 1 "" 299 [Sales_Resp_Code(FN)] Latin1_General_CI_AS NULL
295 SQLCHAR 0 1 "" 300 [IT_Mngt_Resp_Code(FN)] Latin1_General_CI_AS NULL
296 SQLCHAR 0 1 "" 301 [Fleet_Mngt_Resp_Code(FN)] Latin1_General_CI_AS NULL
297 SQLCHAR 0 1 "" 302 [Purchase_Mngt_Resp_Cd(FN)] Latin1_General_CI_AS NULL
298 SQLCHAR 0 1 "" 303 [Senior_Decision_Maker(FN)] Latin1_General_CI_AS NULL
299 SQLCHAR 0 1 "" 304 [Tech_Comm_Resp_Code(FN)] Latin1_General_CI_AS NULL
300 SQLCHAR 0 1 "" 305 [Network_Resp_Code(FN)] Latin1_General_CI_AS NULL
301 SQLCHAR 0 60 "" 306 [FIN_MAIL] Latin1_General_CI_AS NULL
302 SQLCHAR 0 2 "" 308 [EMS_Codes(MR)] Latin1_General_CI_AS NULL
303 SQLCHAR 0 32 "" 309 [MARK_FNAME] Latin1_General_CI_AS NULL
304 SQLCHAR 0 32 "" 310 [MARK_SNAME] Latin1_General_CI_AS NULL
305 SQLCHAR 0 40 "" 311 [MARK_FUNC] Latin1_General_CI_AS NULL
306 SQLCHAR 0 40 "" 312 [MARK_SAL] Latin1_General_CI_AS NULL
307 SQLCHAR 0 1 "" 313 [MARK_SEX] Latin1_General_CI_AS NULL
308 SQLCHAR 0 11 "" 314 [Person_ID(MR)] Latin1_General_CI_AS NULL
309 SQLCHAR 0 1 "" 315 [Fin_Resp_Code(MR)] Latin1_General_CI_AS NULL
310 SQLCHAR 0 1 "" 316 [Mrk_Resp_Code(MR)] Latin1_General_CI_AS NULL
311 SQLCHAR 0 1 "" 317 [HR_Resp_Code(MR)] Latin1_General_CI_AS NULL
312 SQLCHAR 0 1 "" 318 [Sales_Resp_Code(MR)] Latin1_General_CI_AS NULL
313 SQLCHAR 0 1 "" 319 [IT_Mngt_Resp_Code(MR)] Latin1_General_CI_AS NULL
314 SQLCHAR 0 1 "" 320 [Fleet_Mngt_Resp_Code(MR)] Latin1_General_CI_AS NULL
315 SQLCHAR 0 1 "" 321 [Purchase_Mngt_Resp_Cd(MR)] Latin1_General_CI_AS NULL
316 SQLCHAR 0 1 "" 322 [Senior_Decision_Maker(MR)] Latin1_General_CI_AS NULL
317 SQLCHAR 0 1 "" 323 [Tech_Comm_Resp_Code(MR)] Latin1_General_CI_AS NULL
318 SQLCHAR 0 1 "" 324 [Network_Resp_Code(MR)] Latin1_General_CI_AS NULL
319 SQLCHAR 0 60 "" 325 [MARK_MAIL] Latin1_General_CI_AS NULL
320 SQLCHAR 0 2 "" 327 [EMS_Codes(HR)] Latin1_General_CI_AS NULL
321 SQLCHAR 0 32 "" 328 [HR_FNAME] Latin1_General_CI_AS NULL
322 SQLCHAR 0 32 "" 329 [HR_SNAME] Latin1_General_CI_AS NULL
323 SQLCHAR 0 40 "" 330 [HR_FUNC] Latin1_General_CI_AS NULL
324 SQLCHAR 0 40 "" 331 [HR_SAL] Latin1_General_CI_AS NULL
325 SQLCHAR 0 1 "" 332 [HR_SEX] Latin1_General_CI_AS NULL
326 SQLCHAR 0 11 "" 333 [Person_ID(HR)] Latin1_General_CI_AS NULL
327 SQLCHAR 0 1 "" 334 [Fin_Resp_Code(HR)] Latin1_General_CI_AS NULL
328 SQLCHAR 0 1 "" 335 [Mrk_Resp_Code(HR)] Latin1_General_CI_AS NULL
329 SQLCHAR 0 1 "" 336 [HR_Resp_Code(HR)] Latin1_General_CI_AS NULL
330 SQLCHAR 0 1 "" 337 [Sales_Resp_Code(HR)] Latin1_General_CI_AS NULL
331 SQLCHAR 0 1 "" 338 [IT_Mngt_Resp_Code(HR)] Latin1_General_CI_AS NULL
332 SQLCHAR 0 1 "" 339 [Fleet_Mngt_Resp_Code(HR)] Latin1_General_CI_AS NULL
333 SQLCHAR 0 1 "" 340 [Purchase_Mngt_Resp_Cd(HR)] Latin1_General_CI_AS NULL
334 SQLCHAR 0 1 "" 341 [Senior_Decision_Maker(HR)] Latin1_General_CI_AS NULL
335 SQLCHAR 0 1 "" 342 [Tech_Comm_Resp_Code(HR)] Latin1_General_CI_AS NULL
336 SQLCHAR 0 1 "" 343 [Network_Resp_Code(HR)] Latin1_General_CI_AS NULL
337 SQLCHAR 0 60 "" 344 [HR_MAIL] Latin1_General_CI_AS NULL
338 SQLCHAR 0 2 "" 346 [EMS_Codes(SR)] Latin1_General_CI_AS NULL
339 SQLCHAR 0 32 "" 347 [SALES_FNAM] Latin1_General_CI_AS NULL
340 SQLCHAR 0 32 "" 348 [SALES_SNAM] Latin1_General_CI_AS NULL
341 SQLCHAR 0 40 "" 349 [SALES_FUNC] Latin1_General_CI_AS NULL
342 SQLCHAR 0 40 "" 350 [SALES_SAL] Latin1_General_CI_AS NULL
343 SQLCHAR 0 1 "" 351 [SALES_SEX] Latin1_General_CI_AS NULL
344 SQLCHAR 0 11 "" 352 [Person_ID(SR)] Latin1_General_CI_AS NULL
345 SQLCHAR 0 1 "" 353 [Fin_Resp_Code(SR)] Latin1_General_CI_AS NULL
346 SQLCHAR 0 1 "" 354 [Mrk_Resp_Code(SR)] Latin1_General_CI_AS NULL
347 SQLCHAR 0 1 "" 355 [HR_Resp_Code(SR)] Latin1_General_CI_AS NULL
348 SQLCHAR 0 1 "" 356 [Sales_Resp_Code(SR)] Latin1_General_CI_AS NULL
349 SQLCHAR 0 1 "" 357 [IT_Mngt_Resp_Code(SR)] Latin1_General_CI_AS NULL
350 SQLCHAR 0 1 "" 358 [Fleet_Mngt_Resp_Code(SR)] Latin1_General_CI_AS NULL
351 SQLCHAR 0 1 "" 359 [Purchase_Mngt_Resp_Cd(SR)] Latin1_General_CI_AS NULL
352 SQLCHAR 0 1 "" 360 [Senior_Decision_Maker(SR)] Latin1_General_CI_AS NULL
353 SQLCHAR 0 1 "" 361 [Tech_Comm_Resp_Code(SR)] Latin1_General_CI_AS NULL
354 SQLCHAR 0 1 "" 362 [Network_Resp_Code(SR)] Latin1_General_CI_AS NULL
355 SQLCHAR 0 60 "" 363 [SALES_MAIL] Latin1_General_CI_AS NULL
356 SQLCHAR 0 2 "" 365 [EMS_Codes(IT)] Latin1_General_CI_AS NULL
357 SQLCHAR 0 32 "" 366 [IT_FNAME] Latin1_General_CI_AS NULL
358 SQLCHAR 0 32 "" 367 [IT_SNAME] Latin1_General_CI_AS NULL
359 SQLCHAR 0 40 "" 368 [IT_FUNC] Latin1_General_CI_AS NULL
360 SQLCHAR 0 40 "" 369 [IT_SAL] Latin1_General_CI_AS NULL
361 SQLCHAR 0 1 "" 370 [IT_SEX] Latin1_General_CI_AS NULL
362 SQLCHAR 0 11 "" 371 [Person_ID(IT)] Latin1_General_CI_AS NULL
363 SQLCHAR 0 1 "" 372 [Fin_Resp_Code(IT)] Latin1_General_CI_AS NULL
364 SQLCHAR 0 1 "" 373 [Mrk_Resp_Code(IT)] Latin1_General_CI_AS NULL
365 SQLCHAR 0 1 "" 374 [HR_Resp_Code(IT)] Latin1_General_CI_AS NULL
366 SQLCHAR 0 1 "" 375 [Sales_Resp_Code(IT)] Latin1_General_CI_AS NULL
367 SQLCHAR 0 1 "" 376 [IT_Mngt_Resp_Code(IT)] Latin1_General_CI_AS NULL
368 SQLCHAR 0 1 "" 377 [Fleet_Mngt_Resp_Code(IT)] Latin1_General_CI_AS NULL
369 SQLCHAR 0 1 "" 378 [Purchase_Mngt_Resp_Cd(IT)] Latin1_General_CI_AS NULL
370 SQLCHAR 0 1 "" 379 [Senior_Decision_Maker(IT)] Latin1_General_CI_AS NULL
371 SQLCHAR 0 1 "" 380 [Tech_Comm_Resp_Code(IT)] Latin1_General_CI_AS NULL
372 SQLCHAR 0 1 "" 381 [Network_Resp_Code(IT)] Latin1_General_CI_AS NULL
373 SQLCHAR 0 60 "" 382 [IT_MAIL] Latin1_General_CI_AS NULL
374 SQLCHAR 0 2 "" 384 [EMS_Codes(FM)] Latin1_General_CI_AS NULL
375 SQLCHAR 0 32 "" 385 [FLEET_FNAM] Latin1_General_CI_AS NULL
376 SQLCHAR 0 32 "" 386 [FLEET_SNAM] Latin1_General_CI_AS NULL
377 SQLCHAR 0 40 "" 387 [FLEET_FUNC] Latin1_General_CI_AS NULL
378 SQLCHAR 0 40 "" 388 [FLEET_SAL] Latin1_General_CI_AS NULL
379 SQLCHAR 0 1 "" 389 [FLEET_SEX] Latin1_General_CI_AS NULL
380 SQLCHAR 0 11 "" 390 [Person_ID(FM)] Latin1_General_CI_AS NULL
381 SQLCHAR 0 1 "" 391 [Fin_Resp_Code(FM)] Latin1_General_CI_AS NULL
382 SQLCHAR 0 1 "" 392 [Mrk_Resp_Code(FM)] Latin1_General_CI_AS NULL
383 SQLCHAR 0 1 "" 393 [HR_Resp_Code(FM)] Latin1_General_CI_AS NULL
384 SQLCHAR 0 1 "" 394 [Sales_Resp_Code(FM)] Latin1_General_CI_AS NULL
385 SQLCHAR 0 1 "" 395 [IT_Mngt_Resp_Code(FM)] Latin1_General_CI_AS NULL
386 SQLCHAR 0 1 "" 396 [Fleet_Mngt_Resp_Code(FM)] Latin1_General_CI_AS NULL
387 SQLCHAR 0 1 "" 397 [Purchase_Mngt_Resp_Cd(FM)] Latin1_General_CI_AS NULL
388 SQLCHAR 0 1 "" 398 [Senior_Decision_Maker(FM)] Latin1_General_CI_AS NULL
389 SQLCHAR 0 1 "" 399 [Tech_Comm_Resp_Code(FM)] Latin1_General_CI_AS NULL
390 SQLCHAR 0 1 "" 400 [Network_Resp_Code(FM)] Latin1_General_CI_AS NULL
391 SQLCHAR 0 60 "" 401 [FLEET_MAIL] Latin1_General_CI_AS NULL
392 SQLCHAR 0 2 "" 403 [EMS_Codes(PM)] Latin1_General_CI_AS NULL
393 SQLCHAR 0 32 "" 404 [PUR_FNAM] Latin1_General_CI_AS NULL
394 SQLCHAR 0 32 "" 405 [PUR_SNAM] Latin1_General_CI_AS NULL
395 SQLCHAR 0 40 "" 406 [PUR_FUNC] Latin1_General_CI_AS NULL
396 SQLCHAR 0 40 "" 407 [PUR_SAL] Latin1_General_CI_AS NULL
397 SQLCHAR 0 1 "" 408 [PUR_SEX] Latin1_General_CI_AS NULL
398 SQLCHAR 0 11 "" 409 [Person_ID(PM)] Latin1_General_CI_AS NULL
399 SQLCHAR 0 1 "" 410 [Fin_Resp_Code(PM)] Latin1_General_CI_AS NULL
400 SQLCHAR 0 1 "" 411 [Mrk_Resp_Code(PM)] Latin1_General_CI_AS NULL
401 SQLCHAR 0 1 "" 412 [HR_Resp_Code(PM)] Latin1_General_CI_AS NULL
402 SQLCHAR 0 1 "" 413 [Sales_Resp_Code(PM)] Latin1_General_CI_AS NULL
403 SQLCHAR 0 1 "" 414 [IT_Mngt_Resp_Code(PM)] Latin1_General_CI_AS NULL
404 SQLCHAR 0 1 "" 415 [Fleet_Mngt_Resp_Code(PM)] Latin1_General_CI_AS NULL
405 SQLCHAR 0 1 "" 416 [Purchase_Mngt_Resp_Cd(PM)] Latin1_General_CI_AS NULL
406 SQLCHAR 0 1 "" 417 [Senior_Decision_Maker(PM)] Latin1_General_CI_AS NULL
407 SQLCHAR 0 1 "" 418 [Tech_Comm_Resp_Code(PM)] Latin1_General_CI_AS NULL
408 SQLCHAR 0 1 "" 419 [Network_Resp_Code(PM)] Latin1_General_CI_AS NULL
409 SQLCHAR 0 60 "" 420 [PUR_MAIL] Latin1_General_CI_AS NULL
410 SQLCHAR 0 2 "" 422 [EMS_Codes(SD)] Latin1_General_CI_AS NULL
411 SQLCHAR 0 32 "" 423 [SEN_FNAM] Latin1_General_CI_AS NULL
412 SQLCHAR 0 32 "" 424 [SEN_SNAM] Latin1_General_CI_AS NULL
413 SQLCHAR 0 40 "" 425 [SEN_FUNC] Latin1_General_CI_AS NULL
414 SQLCHAR 0 40 "" 426 [SEN_SAL] Latin1_General_CI_AS NULL
415 SQLCHAR 0 1 "" 427 [SEN_SEX] Latin1_General_CI_AS NULL
416 SQLCHAR 0 11 "" 428 [Person_ID(SD)] Latin1_General_CI_AS NULL
417 SQLCHAR 0 1 "" 429 [Fin_Resp_Code(SD)] Latin1_General_CI_AS NULL
418 SQLCHAR 0 1 "" 430 [Mrk_Resp_Code(SD)] Latin1_General_CI_AS NULL
419 SQLCHAR 0 1 "" 431 [HR_Resp_Code(SD)] Latin1_General_CI_AS NULL
420 SQLCHAR 0 1 "" 432 [Sales_Resp_Code(SD)] Latin1_General_CI_AS NULL
421 SQLCHAR 0 1 "" 433 [IT_Mngt_Resp_Code(SD)] Latin1_General_CI_AS NULL
422 SQLCHAR 0 1 "" 434 [Fleet_Mngt_Resp_Code(SD)] Latin1_General_CI_AS NULL
423 SQLCHAR 0 1 "" 435 [Purchase_Mngt_Resp_Cd(SD)] Latin1_General_CI_AS NULL
424 SQLCHAR 0 1 "" 436 [Senior_Decision_Maker(SD)] Latin1_General_CI_AS NULL
425 SQLCHAR 0 1 "" 437 [Tech_Comm_Resp_Code(SD)] Latin1_General_CI_AS NULL
426 SQLCHAR 0 1 "" 438 [Network_Resp_Code(SD)] Latin1_General_CI_AS NULL
427 SQLCHAR 0 60 "" 439 [SEN_MAIL] Latin1_General_CI_AS NULL
428 SQLCHAR 0 2 "" 441 [EMS_Codes(TC)] Latin1_General_CI_AS NULL
429 SQLCHAR 0 32 "" 442 [TEL_FNAM] Latin1_General_CI_AS NULL
430 SQLCHAR 0 32 "" 443 [TEL_SNAM] Latin1_General_CI_AS NULL
431 SQLCHAR 0 40 "" 444 [TEL_FUNC] Latin1_General_CI_AS NULL
432 SQLCHAR 0 40 "" 445 [TEL_SAL] Latin1_General_CI_AS NULL
433 SQLCHAR 0 1 "" 446 [TEL_SEX] Latin1_General_CI_AS NULL
434 SQLCHAR 0 11 "" 447 [Person_ID(TC)] Latin1_General_CI_AS NULL
435 SQLCHAR 0 1 "" 448 [Fin_Resp_Code(TC)] Latin1_General_CI_AS NULL
436 SQLCHAR 0 1 "" 449 [Mrk_Resp_Code(TC)] Latin1_General_CI_AS NULL
437 SQLCHAR 0 1 "" 450 [HR_Resp_Code(TC)] Latin1_General_CI_AS NULL
438 SQLCHAR 0 1 "" 451 [Sales_Resp_Code(TC)] Latin1_General_CI_AS NULL
439 SQLCHAR 0 1 "" 452 [IT_Mngt_Resp_Code(TC)] Latin1_General_CI_AS NULL
440 SQLCHAR 0 1 "" 453 [Fleet_Mngt_Resp_Code(TC)] Latin1_General_CI_AS NULL
441 SQLCHAR 0 1 "" 454 [Purchase_Mngt_Resp_Cd(TC)] Latin1_General_CI_AS NULL
442 SQLCHAR 0 1 "" 455 [Senior_Decision_Maker(TC)] Latin1_General_CI_AS NULL
443 SQLCHAR 0 1 "" 456 [Tech_Comm_Resp_Code(TC)] Latin1_General_CI_AS NULL
444 SQLCHAR 0 1 "" 457 [Network_Resp_Code(TC)] Latin1_General_CI_AS NULL
445 SQLCHAR 0 60 "" 458 [TEL_MAIL] Latin1_General_CI_AS NULL
446 SQLCHAR 0 2 "" 460 [EMS_Codes(NM)] Latin1_General_CI_AS NULL
447 SQLCHAR 0 32 "" 461 [NET_FNAM] Latin1_General_CI_AS NULL
448 SQLCHAR 0 32 "" 462 [NET_SNAM] Latin1_General_CI_AS NULL
449 SQLCHAR 0 40 "" 463 [NET_FUNC] Latin1_General_CI_AS NULL
450 SQLCHAR 0 40 "" 464 [NET_SAL] Latin1_General_CI_AS NULL
451 SQLCHAR 0 1 "" 465 [NET_SEX] Latin1_General_CI_AS NULL
452 SQLCHAR 0 11 "" 466 [Person_ID(NM)] Latin1_General_CI_AS NULL
453 SQLCHAR 0 1 "" 467 [Fin_Resp_Code(NM)] Latin1_General_CI_AS NULL
454 SQLCHAR 0 1 "" 468 [Mrk_Resp_Code(NM)] Latin1_General_CI_AS NULL
455 SQLCHAR 0 1 "" 469 [HR_Resp_Code(NM)] Latin1_General_CI_AS NULL
456 SQLCHAR 0 1 "" 470 [Sales_Resp_Code(NM)] Latin1_General_CI_AS NULL
457 SQLCHAR 0 1 "" 471 [IT_Mngt_Resp_Code(NM)] Latin1_General_CI_AS NULL
458 SQLCHAR 0 1 "" 472 [Fleet_Mngt_Resp_Code(NM)] Latin1_General_CI_AS NULL
459 SQLCHAR 0 1 "" 473 [Purchase_Mngt_Resp_Cd(NM)] Latin1_General_CI_AS NULL
460 SQLCHAR 0 1 "" 474 [Senior_Decision_Maker(NM)] Latin1_General_CI_AS NULL
461 SQLCHAR 0 1 "" 475 [Tech_Comm_Resp_Code(NM)] Latin1_General_CI_AS NULL
462 SQLCHAR 0 1 "" 476 [Network_Resp_Code(NM)] Latin1_General_CI_AS NULL
463 SQLCHAR 0 60 "" 477 [NET_MAIL] Latin1_General_CI_AS NULL
464 SQLCHAR 0 2 "" 478 [Postcode_Band] Latin1_General_CI_AS NULL
465 SQLCHAR 0 27 "" 479 [Sales_Band] Latin1_General_CI_AS NULL
466 SQLCHAR 0 15 "" 480 [EMPS_COMP_BAND] Latin1_General_CI_AS NULL
467 SQLCHAR 0 15 "" 481 [EMPS_SITE_BAND] Latin1_General_CI_AS NULL
468 SQLCHAR 0 43 "" 482 [US_SIC_Band] Latin1_General_CI_AS NULL
469 SQLCHAR 0 2 "" 483 [Customised_Universe_Ind] Latin1_General_CI_AS NULL
470 SQLCHAR 0 2 "" 484 [Record_Category] Latin1_General_CI_AS NULL
471 SQLCHAR 0 2 "" 485 [Demand_Estimator_1] Latin1_General_CI_AS NULL
472 SQLCHAR 0 2 "" 486 [Demand_Estimator_2] Latin1_General_CI_AS NULL
473 SQLCHAR 0 2 "" 487 [Demand_Estimator_3] Latin1_General_CI_AS NULL
474 SQLCHAR 0 2 "" 488 [Demand_Estimator_4] Latin1_General_CI_AS NULL
475 SQLCHAR 0 2 "" 489 [Demand_Estimator_5] Latin1_General_CI_AS NULL
476 SQLCHAR 0 2 "" 490 [Demand_Estimator_6] Latin1_General_CI_AS NULL
477 SQLCHAR 0 1 "" 491 [SMU_IND] Latin1_General_CI_AS NULL
478 SQLCHAR 0 60 "" 492 [URL] Latin1_General_CI_AS NULL
479 SQLCHAR 0 60 "\r\n" 493 [COMP_MAIL] Latin1_General_CI_AS NULL

nr
SQLTeam MVY

12543 Posts
Posted - 2006-05-15 : 11:23:32
DO you have 493 cols in the destination?
Are you sure you don't have a duplicate?

Cut down the table and format file until you find the entry that's causing the problem.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

starnold
Yak Posting Veteran

83 Posts
Posted - 2006-05-15 : 11:29:04
The destination has 514 fields, but the source definitly has 479 fields in them. We are trying to push the source into a table with more columns. We then use the imported data to populate the other columns in the SQL table
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site