BCP question

Hi Guys
I have a client who was having issues importing from a text file (Created by
there mainframe ) into SQL server, using DTS it would only import a certain
number of the rows (like 10 000 out of a million) we hare now trying to use
BCP and see the following problem below:
C:\>bcp CARD..AVAAF_ABSA_Employee in
c:\1ECLS_EMP.txt -fc:\1formatfile.fmt -Sman
netjie -Usa -Ppassword
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]I/O error while reading BCP
format file
This is the format of the clients format file:
8.0
25
1 SQLCHAR 2 2 "\0" 0 num1
SQL_Latin1_General_Cp437_BIN
2 SQLCHAR 2 7 "\0" 10 Employee_no
SQL_Latin1_General_Cp437_BIN
3 SQLCHAR 2 7 "\0" 1 AB_Number
SQL_Latin1_General_Cp437_BIN
4 SQLCHAR 2 30 "\0" 3 Surname
SQL_Latin1_General_Cp437_BIN
5 SQLCHAR 2 20 "\0" 4 Name SQL_Latin1_General_Cp437_BIN
6 SQLCHAR 2 10 "\0" 2 Initials
SQL_Latin1_General_Cp437_BIN
7 SQLCHAR 2 20 "\0" 0 num2
SQL_Latin1_General_Cp437_BIN
8 SQLCHAR 2 50 "\0" 11 EmailAddress
SQL_Latin1_General_Cp437_BIN
9 SQLCHAR 2 12 "\0" 0 num3
SQL_Latin1_General_Cp437_BIN
10 SQLCHAR 2 10 "\0" 0 num4
SQL_Latin1_General_Cp437_BIN
11 SQLCHAR 2 40 "\0" 0 num5
SQL_Latin1_General_Cp437_BIN
12 SQLCHAR 2 4 "\0" 0 num6
SQL_Latin1_General_Cp437_BIN
13 SQLCHAR 2 40 "\0" 0 num7
SQL_Latin1_General_Cp437_BIN
14 SQLCHAR 2 20 "\0" 5 TelephoneNumber SQL_Latin1_General_Cp437_BIN
15 SQLCHAR 2 20 "\0" 7 FaxNumber SQL_Latin1_General_Cp437_BIN
16 SQLCHAR 2 12 "\0" 6 CellularNumber SQL_Latin1_General_Cp437_BIN
17 SQLCHAR 2 56 "\0" 0 num8
SQL_Latin1_General_Cp437_BIN
18 SQLCHAR 2 40 "\0" 9 DomicileAdddress SQL_Latin1_General_Cp437_BIN
19 SQLCHAR 2 40 "\0" 0 num9
SQL_Latin1_General_Cp437_BIN
20 SQLCHAR 2 10 "\0" 0 num10
SQL_Latin1_General_Cp437_BIN
21 SQLCHAR 2 4 "\0" 0 num11
SQL_Latin1_General_Cp437_BIN
22 SQLCHAR 2 40 "\0" 0 num12
SQL_Latin1_General_Cp437_BIN
23 SQLCHAR 2 40 "\0" 0 num13
SQL_Latin1_General_Cp437_BIN
24 SQLCHAR 2 2 "\0" 0 num14
SQL_Latin1_General_Cp437_BIN
25 SQLCHAR 2 16 "\r\n" 15 Province SQL_Latin1_General_Cp437_BIN
I cannot find any info on this error message , has anyone got any ideas,
this is SQL server 2000 SP3
Thanks
Dylan
Have you checked the event log to verify you are not getting Disk I/O
errors?
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
news:ev0WvtNaEHA.2892@.TK2MSFTNGP10.phx.gbl...
> Hi Guys
> I have a client who was having issues importing from a text file (Created
by
> there mainframe ) into SQL server, using DTS it would only import a
certain
> number of the rows (like 10 000 out of a million) we hare now trying to
use
> BCP and see the following problem below:
>
> C:\>bcp CARD..AVAAF_ABSA_Employee in
> c:\1ECLS_EMP.txt -fc:\1formatfile.fmt -Sman
>
> netjie -Usa -Ppassword
>
> SQLState = S1000, NativeError = 0
>
> Error = [Microsoft][ODBC SQL Server Driver]I/O error while reading BCP
> format file
>
> This is the format of the clients format file:
>
> 8.0
> 25
> 1 SQLCHAR 2 2 "\0" 0 num1
> SQL_Latin1_General_Cp437_BIN
> 2 SQLCHAR 2 7 "\0" 10 Employee_no
> SQL_Latin1_General_Cp437_BIN
> 3 SQLCHAR 2 7 "\0" 1 AB_Number
> SQL_Latin1_General_Cp437_BIN
> 4 SQLCHAR 2 30 "\0" 3 Surname
> SQL_Latin1_General_Cp437_BIN
> 5 SQLCHAR 2 20 "\0" 4 Name SQL_Latin1_General_Cp437_BIN
> 6 SQLCHAR 2 10 "\0" 2 Initials
> SQL_Latin1_General_Cp437_BIN
> 7 SQLCHAR 2 20 "\0" 0 num2
> SQL_Latin1_General_Cp437_BIN
> 8 SQLCHAR 2 50 "\0" 11 EmailAddress
> SQL_Latin1_General_Cp437_BIN
> 9 SQLCHAR 2 12 "\0" 0 num3
> SQL_Latin1_General_Cp437_BIN
> 10 SQLCHAR 2 10 "\0" 0 num4
> SQL_Latin1_General_Cp437_BIN
> 11 SQLCHAR 2 40 "\0" 0 num5
> SQL_Latin1_General_Cp437_BIN
> 12 SQLCHAR 2 4 "\0" 0 num6
> SQL_Latin1_General_Cp437_BIN
> 13 SQLCHAR 2 40 "\0" 0 num7
> SQL_Latin1_General_Cp437_BIN
> 14 SQLCHAR 2 20 "\0" 5 TelephoneNumber
SQL_Latin1_General_Cp437_BIN
> 15 SQLCHAR 2 20 "\0" 7 FaxNumber
SQL_Latin1_General_Cp437_BIN
> 16 SQLCHAR 2 12 "\0" 6 CellularNumber
SQL_Latin1_General_Cp437_BIN
> 17 SQLCHAR 2 56 "\0" 0 num8
> SQL_Latin1_General_Cp437_BIN
> 18 SQLCHAR 2 40 "\0" 9 DomicileAdddress
SQL_Latin1_General_Cp437_BIN
> 19 SQLCHAR 2 40 "\0" 0 num9
> SQL_Latin1_General_Cp437_BIN
> 20 SQLCHAR 2 10 "\0" 0 num10
> SQL_Latin1_General_Cp437_BIN
> 21 SQLCHAR 2 4 "\0" 0 num11
> SQL_Latin1_General_Cp437_BIN
> 22 SQLCHAR 2 40 "\0" 0 num12
> SQL_Latin1_General_Cp437_BIN
> 23 SQLCHAR 2 40 "\0" 0 num13
> SQL_Latin1_General_Cp437_BIN
> 24 SQLCHAR 2 2 "\0" 0 num14
> SQL_Latin1_General_Cp437_BIN
> 25 SQLCHAR 2 16 "\r\n" 15 Province
SQL_Latin1_General_Cp437_BIN
>
>
> I cannot find any info on this error message , has anyone got any ideas,
> this is SQL server 2000 SP3
>
> Thanks
> Dylan
>
|||I have not as i thought it would be unlikely that it owuld be that , but i
will check it anyways ,
Thanks
"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:u6mlGkOaEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Have you checked the event log to verify you are not getting Disk I/O
> errors?
> --
> ----
--
> ----
--[vbcol=seagreen]
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
> news:ev0WvtNaEHA.2892@.TK2MSFTNGP10.phx.gbl...
(Created
> by
> certain
> use
> SQL_Latin1_General_Cp437_BIN
> SQL_Latin1_General_Cp437_BIN
> SQL_Latin1_General_Cp437_BIN
> SQL_Latin1_General_Cp437_BIN
> SQL_Latin1_General_Cp437_BIN
>
|||hi Dylan,
I to am getting the same error of bcp you getting. Did you find the cause...if so please let me know.
Thanks
Arzan
"Dylan Kruger" wrote:

> I have not as i thought it would be unlikely that it owuld be that , but i
> will check it anyways ,
> Thanks
> "Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
> news:u6mlGkOaEHA.1764@.TK2MSFTNGP10.phx.gbl...
> --
> --
> (Created
>
>
sql

BCP question

Hi Guys
I have a client who was having issues importing from a text file (Created by
there mainframe ) into SQL server, using DTS it would only import a certain
number of the rows (like 10 000 out of a million) we hare now trying to use
BCP and see the following problem below:
C:\>bcp CARD..AVAAF_ABSA_Employee in
c:\1ECLS_EMP.txt -fc:\1formatfile.fmt -Sman
netjie -Usa -Ppassword
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]I/O error while reading B
CP
format file
This is the format of the clients format file:
8.0
25
1 SQLCHAR 2 2 "\0" 0 num1
SQL_Latin1_General_Cp437_BIN
2 SQLCHAR 2 7 "\0" 10 Employee_no
SQL_Latin1_General_Cp437_BIN
3 SQLCHAR 2 7 "\0" 1 AB_Number
SQL_Latin1_General_Cp437_BIN
4 SQLCHAR 2 30 "\0" 3 Surname
SQL_Latin1_General_Cp437_BIN
5 SQLCHAR 2 20 "\0" 4 Name SQL_Latin1_General_Cp437_BIN
6 SQLCHAR 2 10 "\0" 2 Initials
SQL_Latin1_General_Cp437_BIN
7 SQLCHAR 2 20 "\0" 0 num2
SQL_Latin1_General_Cp437_BIN
8 SQLCHAR 2 50 "\0" 11 EmailAddress
SQL_Latin1_General_Cp437_BIN
9 SQLCHAR 2 12 "\0" 0 num3
SQL_Latin1_General_Cp437_BIN
10 SQLCHAR 2 10 "\0" 0 num4
SQL_Latin1_General_Cp437_BIN
11 SQLCHAR 2 40 "\0" 0 num5
SQL_Latin1_General_Cp437_BIN
12 SQLCHAR 2 4 "\0" 0 num6
SQL_Latin1_General_Cp437_BIN
13 SQLCHAR 2 40 "\0" 0 num7
SQL_Latin1_General_Cp437_BIN
14 SQLCHAR 2 20 "\0" 5 TelephoneNumber SQL_Latin1_General_Cp437_BIN
15 SQLCHAR 2 20 "\0" 7 FaxNumber SQL_Latin1_General_Cp437_BIN
16 SQLCHAR 2 12 "\0" 6 CellularNumber SQL_Latin1_General_Cp437_BIN
17 SQLCHAR 2 56 "\0" 0 num8
SQL_Latin1_General_Cp437_BIN
18 SQLCHAR 2 40 "\0" 9 DomicileAdddress SQL_Latin1_General_Cp437_BIN
19 SQLCHAR 2 40 "\0" 0 num9
SQL_Latin1_General_Cp437_BIN
20 SQLCHAR 2 10 "\0" 0 num10
SQL_Latin1_General_Cp437_BIN
21 SQLCHAR 2 4 "\0" 0 num11
SQL_Latin1_General_Cp437_BIN
22 SQLCHAR 2 40 "\0" 0 num12
SQL_Latin1_General_Cp437_BIN
23 SQLCHAR 2 40 "\0" 0 num13
SQL_Latin1_General_Cp437_BIN
24 SQLCHAR 2 2 "\0" 0 num14
SQL_Latin1_General_Cp437_BIN
25 SQLCHAR 2 16 "\r\n" 15 Province SQL_Latin1_General_Cp437_BIN
I cannot find any info on this error message , has anyone got any ideas,
this is SQL server 2000 SP3
Thanks
DylanHave you checked the event log to verify you are not getting Disk I/O
errors?
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
news:ev0WvtNaEHA.2892@.TK2MSFTNGP10.phx.gbl...
> Hi Guys
> I have a client who was having issues importing from a text file (Created
by
> there mainframe ) into SQL server, using DTS it would only import a
certain
> number of the rows (like 10 000 out of a million) we hare now trying to
use
> BCP and see the following problem below:
>
> C:\>bcp CARD..AVAAF_ABSA_Employee in
> c:\1ECLS_EMP.txt -fc:\1formatfile.fmt -Sman
>
> netjie -Usa -Ppassword
>
> SQLState = S1000, NativeError = 0
>
> Error = [Microsoft][ODBC SQL Server Driver]I/O error while reading
BCP
> format file
>
> This is the format of the clients format file:
>
> 8.0
> 25
> 1 SQLCHAR 2 2 "\0" 0 num1
> SQL_Latin1_General_Cp437_BIN
> 2 SQLCHAR 2 7 "\0" 10 Employee_no
> SQL_Latin1_General_Cp437_BIN
> 3 SQLCHAR 2 7 "\0" 1 AB_Number
> SQL_Latin1_General_Cp437_BIN
> 4 SQLCHAR 2 30 "\0" 3 Surname
> SQL_Latin1_General_Cp437_BIN
> 5 SQLCHAR 2 20 "\0" 4 Name SQL_Latin1_General_Cp437_BIN
> 6 SQLCHAR 2 10 "\0" 2 Initials
> SQL_Latin1_General_Cp437_BIN
> 7 SQLCHAR 2 20 "\0" 0 num2
> SQL_Latin1_General_Cp437_BIN
> 8 SQLCHAR 2 50 "\0" 11 EmailAddress
> SQL_Latin1_General_Cp437_BIN
> 9 SQLCHAR 2 12 "\0" 0 num3
> SQL_Latin1_General_Cp437_BIN
> 10 SQLCHAR 2 10 "\0" 0 num4
> SQL_Latin1_General_Cp437_BIN
> 11 SQLCHAR 2 40 "\0" 0 num5
> SQL_Latin1_General_Cp437_BIN
> 12 SQLCHAR 2 4 "\0" 0 num6
> SQL_Latin1_General_Cp437_BIN
> 13 SQLCHAR 2 40 "\0" 0 num7
> SQL_Latin1_General_Cp437_BIN
> 14 SQLCHAR 2 20 "\0" 5 TelephoneNumber
SQL_Latin1_General_Cp437_BINeen">
> 15 SQLCHAR 2 20 "\0" 7 FaxNumber
SQL_Latin1_General_Cp437_BINeen">
> 16 SQLCHAR 2 12 "\0" 6 CellularNumber
SQL_Latin1_General_Cp437_BINeen">
> 17 SQLCHAR 2 56 "\0" 0 num8
> SQL_Latin1_General_Cp437_BIN
> 18 SQLCHAR 2 40 "\0" 9 DomicileAdddress
SQL_Latin1_General_Cp437_BINeen">
> 19 SQLCHAR 2 40 "\0" 0 num9
> SQL_Latin1_General_Cp437_BIN
> 20 SQLCHAR 2 10 "\0" 0 num10
> SQL_Latin1_General_Cp437_BIN
> 21 SQLCHAR 2 4 "\0" 0 num11
> SQL_Latin1_General_Cp437_BIN
> 22 SQLCHAR 2 40 "\0" 0 num12
> SQL_Latin1_General_Cp437_BIN
> 23 SQLCHAR 2 40 "\0" 0 num13
> SQL_Latin1_General_Cp437_BIN
> 24 SQLCHAR 2 2 "\0" 0 num14
> SQL_Latin1_General_Cp437_BIN
> 25 SQLCHAR 2 16 "\r\n" 15 Province
SQL_Latin1_General_Cp437_BINeen">
>
>
> I cannot find any info on this error message , has anyone got any ideas,
> this is SQL server 2000 SP3
>
> Thanks
> Dylan
>|||I have not as i thought it would be unlikely that it owuld be that , but i
will check it anyways ,
Thanks
"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:u6mlGkOaEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Have you checked the event log to verify you are not getting Disk I/O
> errors?
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
> news:ev0WvtNaEHA.2892@.TK2MSFTNGP10.phx.gbl...
(Created[vbcol=seagreen]
> by
> certain
> use
> SQL_Latin1_General_Cp437_BIN
> SQL_Latin1_General_Cp437_BIN
> SQL_Latin1_General_Cp437_BIN
> SQL_Latin1_General_Cp437_BIN
> SQL_Latin1_General_Cp437_BIN
>|||hi Dylan,
I to am getting the same error of bcp you getting. Did you find the cause...
if so please let me know.
Thanks
Arzan
"Dylan Kruger" wrote:

> I have not as i thought it would be unlikely that it owuld be that , but i
> will check it anyways ,
> Thanks
> "Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
> news:u6mlGkOaEHA.1764@.TK2MSFTNGP10.phx.gbl...
> --
> --
> (Created
>
>

BCP question

Hi Guys
I have a client who was having issues importing from a text file (Created by
there mainframe ) into SQL server, using DTS it would only import a certain
number of the rows (like 10 000 out of a million) we hare now trying to use
BCP and see the following problem below:
C:\>bcp CARD..AVAAF_ABSA_Employee in
c:\1ECLS_EMP.txt -fc:\1formatfile.fmt -Sman
netjie -Usa -Ppassword
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]I/O error while reading BCP
format file
This is the format of the clients format file:
8.0
25
1 SQLCHAR 2 2 "\0" 0 num1
SQL_Latin1_General_Cp437_BIN
2 SQLCHAR 2 7 "\0" 10 Employee_no
SQL_Latin1_General_Cp437_BIN
3 SQLCHAR 2 7 "\0" 1 AB_Number
SQL_Latin1_General_Cp437_BIN
4 SQLCHAR 2 30 "\0" 3 Surname
SQL_Latin1_General_Cp437_BIN
5 SQLCHAR 2 20 "\0" 4 Name SQL_Latin1_General_Cp437_BIN
6 SQLCHAR 2 10 "\0" 2 Initials
SQL_Latin1_General_Cp437_BIN
7 SQLCHAR 2 20 "\0" 0 num2
SQL_Latin1_General_Cp437_BIN
8 SQLCHAR 2 50 "\0" 11 EmailAddress
SQL_Latin1_General_Cp437_BIN
9 SQLCHAR 2 12 "\0" 0 num3
SQL_Latin1_General_Cp437_BIN
10 SQLCHAR 2 10 "\0" 0 num4
SQL_Latin1_General_Cp437_BIN
11 SQLCHAR 2 40 "\0" 0 num5
SQL_Latin1_General_Cp437_BIN
12 SQLCHAR 2 4 "\0" 0 num6
SQL_Latin1_General_Cp437_BIN
13 SQLCHAR 2 40 "\0" 0 num7
SQL_Latin1_General_Cp437_BIN
14 SQLCHAR 2 20 "\0" 5 TelephoneNumber SQL_Latin1_General_Cp437_BIN
15 SQLCHAR 2 20 "\0" 7 FaxNumber SQL_Latin1_General_Cp437_BIN
16 SQLCHAR 2 12 "\0" 6 CellularNumber SQL_Latin1_General_Cp437_BIN
17 SQLCHAR 2 56 "\0" 0 num8
SQL_Latin1_General_Cp437_BIN
18 SQLCHAR 2 40 "\0" 9 DomicileAdddress SQL_Latin1_General_Cp437_BIN
19 SQLCHAR 2 40 "\0" 0 num9
SQL_Latin1_General_Cp437_BIN
20 SQLCHAR 2 10 "\0" 0 num10
SQL_Latin1_General_Cp437_BIN
21 SQLCHAR 2 4 "\0" 0 num11
SQL_Latin1_General_Cp437_BIN
22 SQLCHAR 2 40 "\0" 0 num12
SQL_Latin1_General_Cp437_BIN
23 SQLCHAR 2 40 "\0" 0 num13
SQL_Latin1_General_Cp437_BIN
24 SQLCHAR 2 2 "\0" 0 num14
SQL_Latin1_General_Cp437_BIN
25 SQLCHAR 2 16 "\r\n" 15 Province SQL_Latin1_General_Cp437_BIN
I cannot find any info on this error message , has anyone got any ideas,
this is SQL server 2000 SP3
Thanks
DylanHave you checked the event log to verify you are not getting Disk I/O
errors?
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
news:ev0WvtNaEHA.2892@.TK2MSFTNGP10.phx.gbl...
> Hi Guys
> I have a client who was having issues importing from a text file (Created
by
> there mainframe ) into SQL server, using DTS it would only import a
certain
> number of the rows (like 10 000 out of a million) we hare now trying to
use
> BCP and see the following problem below:
>
> C:\>bcp CARD..AVAAF_ABSA_Employee in
> c:\1ECLS_EMP.txt -fc:\1formatfile.fmt -Sman
>
> netjie -Usa -Ppassword
>
> SQLState = S1000, NativeError = 0
>
> Error = [Microsoft][ODBC SQL Server Driver]I/O error while reading BCP
> format file
>
> This is the format of the clients format file:
>
> 8.0
> 25
> 1 SQLCHAR 2 2 "\0" 0 num1
> SQL_Latin1_General_Cp437_BIN
> 2 SQLCHAR 2 7 "\0" 10 Employee_no
> SQL_Latin1_General_Cp437_BIN
> 3 SQLCHAR 2 7 "\0" 1 AB_Number
> SQL_Latin1_General_Cp437_BIN
> 4 SQLCHAR 2 30 "\0" 3 Surname
> SQL_Latin1_General_Cp437_BIN
> 5 SQLCHAR 2 20 "\0" 4 Name SQL_Latin1_General_Cp437_BIN
> 6 SQLCHAR 2 10 "\0" 2 Initials
> SQL_Latin1_General_Cp437_BIN
> 7 SQLCHAR 2 20 "\0" 0 num2
> SQL_Latin1_General_Cp437_BIN
> 8 SQLCHAR 2 50 "\0" 11 EmailAddress
> SQL_Latin1_General_Cp437_BIN
> 9 SQLCHAR 2 12 "\0" 0 num3
> SQL_Latin1_General_Cp437_BIN
> 10 SQLCHAR 2 10 "\0" 0 num4
> SQL_Latin1_General_Cp437_BIN
> 11 SQLCHAR 2 40 "\0" 0 num5
> SQL_Latin1_General_Cp437_BIN
> 12 SQLCHAR 2 4 "\0" 0 num6
> SQL_Latin1_General_Cp437_BIN
> 13 SQLCHAR 2 40 "\0" 0 num7
> SQL_Latin1_General_Cp437_BIN
> 14 SQLCHAR 2 20 "\0" 5 TelephoneNumber
SQL_Latin1_General_Cp437_BIN
> 15 SQLCHAR 2 20 "\0" 7 FaxNumber
SQL_Latin1_General_Cp437_BIN
> 16 SQLCHAR 2 12 "\0" 6 CellularNumber
SQL_Latin1_General_Cp437_BIN
> 17 SQLCHAR 2 56 "\0" 0 num8
> SQL_Latin1_General_Cp437_BIN
> 18 SQLCHAR 2 40 "\0" 9 DomicileAdddress
SQL_Latin1_General_Cp437_BIN
> 19 SQLCHAR 2 40 "\0" 0 num9
> SQL_Latin1_General_Cp437_BIN
> 20 SQLCHAR 2 10 "\0" 0 num10
> SQL_Latin1_General_Cp437_BIN
> 21 SQLCHAR 2 4 "\0" 0 num11
> SQL_Latin1_General_Cp437_BIN
> 22 SQLCHAR 2 40 "\0" 0 num12
> SQL_Latin1_General_Cp437_BIN
> 23 SQLCHAR 2 40 "\0" 0 num13
> SQL_Latin1_General_Cp437_BIN
> 24 SQLCHAR 2 2 "\0" 0 num14
> SQL_Latin1_General_Cp437_BIN
> 25 SQLCHAR 2 16 "\r\n" 15 Province
SQL_Latin1_General_Cp437_BIN
>
>
> I cannot find any info on this error message , has anyone got any ideas,
> this is SQL server 2000 SP3
>
> Thanks
> Dylan
>|||I have not as i thought it would be unlikely that it owuld be that , but i
will check it anyways ,
Thanks
"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:u6mlGkOaEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Have you checked the event log to verify you are not getting Disk I/O
> errors?
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
> news:ev0WvtNaEHA.2892@.TK2MSFTNGP10.phx.gbl...
> > Hi Guys
> >
> > I have a client who was having issues importing from a text file
(Created
> by
> > there mainframe ) into SQL server, using DTS it would only import a
> certain
> > number of the rows (like 10 000 out of a million) we hare now trying to
> use
> > BCP and see the following problem below:
> >
> >
> >
> > C:\>bcp CARD..AVAAF_ABSA_Employee in
> > c:\1ECLS_EMP.txt -fc:\1formatfile.fmt -Sman
> >
> >
> >
> > netjie -Usa -Ppassword
> >
> >
> >
> > SQLState = S1000, NativeError = 0
> >
> >
> >
> > Error = [Microsoft][ODBC SQL Server Driver]I/O error while reading BCP
> > format file
> >
> >
> >
> > This is the format of the clients format file:
> >
> >
> >
> > 8.0
> >
> > 25
> >
> > 1 SQLCHAR 2 2 "\0" 0 num1
> > SQL_Latin1_General_Cp437_BIN
> >
> > 2 SQLCHAR 2 7 "\0" 10 Employee_no
> > SQL_Latin1_General_Cp437_BIN
> >
> > 3 SQLCHAR 2 7 "\0" 1 AB_Number
> > SQL_Latin1_General_Cp437_BIN
> >
> > 4 SQLCHAR 2 30 "\0" 3 Surname
> > SQL_Latin1_General_Cp437_BIN
> >
> > 5 SQLCHAR 2 20 "\0" 4 Name SQL_Latin1_General_Cp437_BIN
> >
> > 6 SQLCHAR 2 10 "\0" 2 Initials
> > SQL_Latin1_General_Cp437_BIN
> >
> > 7 SQLCHAR 2 20 "\0" 0 num2
> > SQL_Latin1_General_Cp437_BIN
> >
> > 8 SQLCHAR 2 50 "\0" 11 EmailAddress
> > SQL_Latin1_General_Cp437_BIN
> >
> > 9 SQLCHAR 2 12 "\0" 0 num3
> > SQL_Latin1_General_Cp437_BIN
> >
> > 10 SQLCHAR 2 10 "\0" 0 num4
> > SQL_Latin1_General_Cp437_BIN
> >
> > 11 SQLCHAR 2 40 "\0" 0 num5
> > SQL_Latin1_General_Cp437_BIN
> >
> > 12 SQLCHAR 2 4 "\0" 0 num6
> > SQL_Latin1_General_Cp437_BIN
> >
> > 13 SQLCHAR 2 40 "\0" 0 num7
> > SQL_Latin1_General_Cp437_BIN
> >
> > 14 SQLCHAR 2 20 "\0" 5 TelephoneNumber
> SQL_Latin1_General_Cp437_BIN
> >
> > 15 SQLCHAR 2 20 "\0" 7 FaxNumber
> SQL_Latin1_General_Cp437_BIN
> >
> > 16 SQLCHAR 2 12 "\0" 6 CellularNumber
> SQL_Latin1_General_Cp437_BIN
> >
> > 17 SQLCHAR 2 56 "\0" 0 num8
> > SQL_Latin1_General_Cp437_BIN
> >
> > 18 SQLCHAR 2 40 "\0" 9 DomicileAdddress
> SQL_Latin1_General_Cp437_BIN
> >
> > 19 SQLCHAR 2 40 "\0" 0 num9
> > SQL_Latin1_General_Cp437_BIN
> >
> > 20 SQLCHAR 2 10 "\0" 0 num10
> > SQL_Latin1_General_Cp437_BIN
> >
> > 21 SQLCHAR 2 4 "\0" 0 num11
> > SQL_Latin1_General_Cp437_BIN
> >
> > 22 SQLCHAR 2 40 "\0" 0 num12
> > SQL_Latin1_General_Cp437_BIN
> >
> > 23 SQLCHAR 2 40 "\0" 0 num13
> > SQL_Latin1_General_Cp437_BIN
> >
> > 24 SQLCHAR 2 2 "\0" 0 num14
> > SQL_Latin1_General_Cp437_BIN
> >
> > 25 SQLCHAR 2 16 "\r\n" 15 Province
> SQL_Latin1_General_Cp437_BIN
> >
> >
> >
> >
> >
> > I cannot find any info on this error message , has anyone got any ideas,
> > this is SQL server 2000 SP3
> >
> >
> >
> > Thanks
> >
> > Dylan
> >
> >
>

BCP Parameter for Unicode file

Hi,
Can any one suggest the bcp parameter for importing file , which is in unicode format, delimeted by tabs. i tried -w, -N all in vain :-(
TIA,
sudheerWhat do you mean that the input file is in unicode format?

I don't understand...|||Originally posted by Brett Kaiser
What do you mean that the input file is in unicode format?

I don't understand...

I meant the file is in Unicode format

i m using sql server 2000 .

Error message is

SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid

character value for cast spec
ification

and string i used for bcp is

bcp <DBname>..<tablename> in

D:\a.dat -S<servername> -T -m0 -w|||http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_9mwg.asp and verify the data in the file against the data type of the columns. This error usually indicates that the data is incorrectly formatted & is failing to get converted.

http://www.nigelrivett.net/BCP_quoted_CSV_Format_file.html for more help.|||Originally posted by Satya
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_9mwg.asp and verify the data in the file against the data type of the columns. This error usually indicates that the data is incorrectly formatted & is failing to get converted.

http://www.nigelrivett.net/BCP_quoted_CSV_Format_file.html for more help.

Hi,
thnx for info, i solved the prob. the no.of columns in the datafiles and tht of the target table were not matching.

sudheer|||I still want to know what a unicode flat file is...|||I assume that a Unicode flat file is a fixed width columnar report that contains Unicode (16 bit wide characters) data.

-PatP

bcp importing data from fewer fields to more table columns

Hello, please help me with this urgent problem,

I am trying to migrate data from one database to another using the bcp utility. Nowhere in the net I was able to find documentation on how to perform data importation when the destination table has more columns than the fields in my data file. I have a origin table which has 5 columns, and I need to migrate this data to a table that has 20 columns. How to do this? of course I need that the remaining 15 columns of the destination table be filled with NULL data.

From what I have seen, it seems that my xml format file must always have the same amount of <COLUMN> elements than the number of columns in the destination table, is this always so?. If it is, this is a real problem, since I lack 15 <COLUMN> elements in my format file.
I really don't know what can I do about this, pelase help!!

Thanks in advance,
Diego V.

Create a VIEW with the table.columns that match the data file, and BCP into the VIEW. (Be sure the other columns allow NULL values and/or have DEFAULT values.

bcp error - restricted access datatype violation

I got my bcp in and out to work, and also the format file creation.

Now, when i'm importing some of the more strange tables, I get:

SQLState = 07006, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation

I can barely find anything on this by searching on the web - and not anything I can see relevant on MSDN.

I'm guessing the problem is because there are all sorts of float fields in the table, but I don't know, and I don't know how to fix it if it is...

Help!

My code works on smaller, less complicated tables, but not on the bigger monster.

When it fails, does the table have any Text, NText, or Image columns? And are any of these fields Null in 1 or more rows? Is the field type the same in the format file and in the table for these columns?

|||

Nope - but the table is horrendous. There are 500 columns.

SQL Server is creating the format file, I'm using bcp with the format file switches, so I would think that the SQL Server would translate it correctly...The table I'm trying to bcp into is a direct copy of the source table...

Here's the format file:

8.0
504
1 SQLCHAR 2 10 "" 1 LoanNumber SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 2 4 "" 2 ForecastGroup SQL_Latin1_General_CP1_CI_AS
3 SQLCHAR 2 15 "" 3 ForecastGroupRUSH SQL_Latin1_General_CP1_CI_AS
4 SQLCHAR 2 15 "" 4 SourceOfBusiness SQL_Latin1_General_CP1_CI_AS
5 SQLDATETIM4 1 4 "" 5 AppTakenDate ""
6 SQLDATETIM4 1 4 "" 6 AppDate ""
7 SQLDATETIM4 1 4 "" 7 AppWeek ""
8 SQLDATETIM4 1 4 "" 8 AppMonth ""
9 SQLCHAR 2 4 "" 9 LPO SQL_Latin1_General_CP1_CI_AS
10 SQLCHAR 2 4 "" 10 MAP SQL_Latin1_General_CP1_CI_AS
11 SQLCHAR 2 4 "" 11 Region SQL_Latin1_General_CP1_CI_AS
12 SQLCHAR 2 1 "" 12 Division SQL_Latin1_General_CP1_CI_AS
13 SQLCHAR 2 3 "" 13 FundingCompany SQL_Latin1_General_CP1_CI_AS
14 SQLCHAR 2 6 "" 14 ClientCode SQL_Latin1_General_CP1_CI_AS
15 SQLCHAR 2 30 "" 15 ClientName SQL_Latin1_General_CP1_CI_AS
16 SQLCHAR 2 4 "" 16 MarketingProgram SQL_Latin1_General_CP1_CI_AS
17 SQLCHAR 2 3 "" 17 Team SQL_Latin1_General_CP1_CI_AS
18 SQLCHAR 2 2 "" 18 State SQL_Latin1_General_CP1_CI_AS
19 SQLCHAR 2 5 "" 19 ZipCode SQL_Latin1_General_CP1_CI_AS
20 SQLCHAR 2 30 "" 20 DMNumber SQL_Latin1_General_CP1_CI_AS
21 SQLDATETIM4 1 4 "" 21 FundingDate ""
22 SQLDATETIM4 1 4 "" 22 CODAFundingDate ""
23 SQLDATETIM4 1 4 "" 23 CODAFundingWeek ""
24 SQLDATETIM4 1 4 "" 24 CODAFundingMonth ""
25 SQLDATETIM4 1 4 "" 25 OLDCODAFundingDate ""
26 SQLSMALLINT 1 2 "" 26 Funded ""
27 SQLDATETIM4 1 4 "" 27 CancellationDate ""
28 SQLDATETIM4 1 4 "" 28 DenialDate ""
29 SQLSMALLINT 1 2 "" 29 Fallout ""
30 SQLDATETIM4 1 4 "" 30 FalloutDate ""
31 SQLDATETIM4 1 4 "" 31 FalloutWeek ""
32 SQLDATETIM4 1 4 "" 32 FalloutMonth ""
33 SQLDATETIM4 1 4 "" 33 ApplicationDate ""
34 SQLDATETIM4 1 4 "" 34 CreditApprovedDate ""
35 SQLDATETIM4 1 4 "" 35 CreditOrderedDate ""
36 SQLDATETIM4 1 4 "" 36 CreditReceivedDate ""
37 SQLDATETIM4 1 4 "" 37 CreditRejectedDate ""
38 SQLDATETIM4 1 4 "" 38 AppraisalApprovedDate ""
39 SQLDATETIM4 1 4 "" 39 AppraisalOrderedDate ""
40 SQLDATETIM4 1 4 "" 40 AppraisalReceivedDate ""
41 SQLDATETIM4 1 4 "" 41 AppraisalRejectedDate ""
42 SQLDATETIM4 1 4 "" 42 PriceProtectedDate ""
43 SQLDATETIM4 1 4 "" 43 PriceExpirationDate ""
44 SQLDATETIM4 1 4 "" 44 ProjectedCloseDate ""
45 SQLDATETIM4 1 4 "" 45 PropertyDate ""
46 SQLDATETIM4 1 4 "" 46 PaidOffDate ""
47 SQLDATETIM4 1 4 "" 47 ApplicationInconpleteDate ""
48 SQLDATETIM4 1 4 "" 48 ApplicationIncompleteTime ""
49 SQLDATETIM4 1 4 "" 49 ApplicationCompleteDate ""
50 SQLDATETIM4 1 4 "" 50 ApplicationCompleteTime ""
51 SQLDATETIM4 1 4 "" 51 FirstDecisionDate ""
52 SQLDATETIM4 1 4 "" 52 FirstDecisionTime ""
53 SQLDATETIM4 1 4 "" 53 FundingConfirmedDate ""
54 SQLDATETIM4 1 4 "" 54 FundingConfirmedTime ""
55 SQLDATETIM4 1 4 "" 55 ReferralDate ""
56 SQLCHAR 2 1 "" 56 CancelDenialInd SQL_Latin1_General_CP1_CI_AS
57 SQLCHAR 2 1 "" 57 CreditOnlyInd SQL_Latin1_General_CP1_CI_AS
58 SQLCHAR 2 2 "" 58 CreditScore SQL_Latin1_General_CP1_CI_AS
59 SQLCHAR 2 4 "" 59 DenialReason SQL_Latin1_General_CP1_CI_AS
60 SQLCHAR 2 1 "" 60 DocType SQL_Latin1_General_CP1_CI_AS
61 SQLCHAR 2 1 "" 61 EAP SQL_Latin1_General_CP1_CI_AS
62 SQLCHAR 2 1 "" 62 EscrowWaivedInd SQL_Latin1_General_CP1_CI_AS
63 SQLCHAR 2 1 "" 63 LoanType SQL_Latin1_General_CP1_CI_AS
64 SQLCHAR 2 1 "" 64 LoanTypeSimple SQL_Latin1_General_CP1_CI_AS
65 SQLCHAR 2 1 "" 65 ConformingInd SQL_Latin1_General_CP1_CI_AS
66 SQLCHAR 2 1 "" 66 LPMIInd SQL_Latin1_General_CP1_CI_AS
67 SQLCHAR 2 1 "" 67 NewConstructionInd SQL_Latin1_General_CP1_CI_AS
68 SQLCHAR 2 3 "" 68 OriginationSystem SQL_Latin1_General_CP1_CI_AS
69 SQLCHAR 2 6 "" 69 ProductCode SQL_Latin1_General_CP1_CI_AS
70 SQLCHAR 2 6 "" 70 ProgramCode SQL_Latin1_General_CP1_CI_AS
71 SQLCHAR 2 1 "" 71 LoanPurpose SQL_Latin1_General_CP1_CI_AS
72 SQLCHAR 2 1 "" 72 LoanPurposeSimple SQL_Latin1_General_CP1_CI_AS
73 SQLCHAR 2 1 "" 73 RefiRepeatInd SQL_Latin1_General_CP1_CI_AS
74 SQLCHAR 2 1 "" 74 RepeatBorrowerInd SQL_Latin1_General_CP1_CI_AS
75 SQLCHAR 2 2 "" 75 Status SQL_Latin1_General_CP1_CI_AS
76 SQLCHAR 2 3 "" 76 StatusCode SQL_Latin1_General_CP1_CI_AS
77 SQLCHAR 2 1 "" 77 StreamCode SQL_Latin1_General_CP1_CI_AS
78 SQLCHAR 2 1 "" 78 TimeSaverInd SQL_Latin1_General_CP1_CI_AS
79 SQLCHAR 2 4 "" 79 UndewritingAuthorityLevel SQL_Latin1_General_CP1_CI_AS
80 SQLFLT8 1 8 "" 80 LoanAmount ""
81 SQLFLT8 1 8 "" 81 LTV ""
82 SQLFLT8 1 8 "" 82 Price ""
83 SQLINT 1 4 "" 83 AQIScore ""
84 SQLINT 1 4 "" 84 FICOScore ""
85 SQLCHAR 2 9 "" 85 SalesRepConversion SQL_Latin1_General_CP1_CI_AS
86 SQLCHAR 2 9 "" 86 SalesRepLead SQL_Latin1_General_CP1_CI_AS
87 SQLCHAR 2 4 "" 87 MortgageSpecialistProcessor SQL_Latin1_General_CP1_CI_AS
88 SQLCHAR 2 30 "" 88 Underwriter SQL_Latin1_General_CP1_CI_AS
89 SQLCHAR 2 30 "" 89 Closer SQL_Latin1_General_CP1_CI_AS
90 SQLCHAR 2 3 "" 90 CSRInitials SQL_Latin1_General_CP1_CI_AS
91 SQLCHAR 2 30 "" 91 PrefCommMethod SQL_Latin1_General_CP1_CI_AS
92 SQLFLT4 1 4 "" 92 NoteRate ""
93 SQLCHAR 2 1 "" 93 EquityOut SQL_Latin1_General_CP1_CI_AS
94 SQLCHAR 2 2 "" 94 PricingProgram SQL_Latin1_General_CP1_CI_AS
95 SQLCHAR 2 40 "" 95 BorrEMail SQL_Latin1_General_CP1_CI_AS
96 SQLCHAR 2 4 "" 96 LoanSource SQL_Latin1_General_CP1_CI_AS
97 SQLCHAR 2 3 "" 97 PropertyType SQL_Latin1_General_CP1_CI_AS
98 SQLCHAR 2 1 "" 98 LanguagePreference SQL_Latin1_General_CP1_CI_AS
99 SQLDATETIM4 1 4 "" 99 RePriceDate ""
100 SQLCHAR 2 4 "" 100 PM2 SQL_Latin1_General_CP1_CI_AS
101 SQLCHAR 2 10 "" 101 BankTrackingCode SQL_Latin1_General_CP1_CI_AS
102 SQLCHAR 2 10 "" 102 PreviousLoanNumber SQL_Latin1_General_CP1_CI_AS
103 SQLCHAR 2 31 "" 103 PropertyAddress SQL_Latin1_General_CP1_CI_AS
104 SQLCHAR 2 30 "" 104 PropertyCity SQL_Latin1_General_CP1_CI_AS
105 SQLCHAR 2 20 "" 105 BorrowerJobTitle SQL_Latin1_General_CP1_CI_AS
106 SQLCHAR 2 9 "" 106 HESalesRep SQL_Latin1_General_CP1_CI_AS
107 SQLCHAR 2 6 "" 107 HEAU SQL_Latin1_General_CP1_CI_AS
108 SQLCHAR 2 2 "" 108 HEPricingProgram SQL_Latin1_General_CP1_CI_AS
109 SQLFLT4 1 4 "" 109 SecondaryFinancing ""
110 SQLDATETIM4 1 4 "" 110 ActualClosingDate ""
111 SQLDATETIM4 1 4 "" 111 EstimatedClosingDate ""
112 SQLNUMERIC 1 19 "" 112 AppraisalValue ""
113 SQLDATETIM4 1 4 "" 113 CommitExpDate ""
114 SQLCHAR 2 30 "" 114 BorrowerLastName SQL_Latin1_General_CP1_CI_AS
115 SQLCHAR 2 2 "" 115 IncomeTractCode SQL_Latin1_General_CP1_CI_AS
116 SQLCHAR 2 2 "" 116 IncomeRatioCode SQL_Latin1_General_CP1_CI_AS
117 SQLCHAR 2 5 "" 117 Borrower1RaceCode SQL_Latin1_General_CP1_CI_AS
118 SQLCHAR 2 5 "" 118 Borrower2RaceCode SQL_Latin1_General_CP1_CI_AS
119 SQLCHAR 2 5 "" 119 Borrower3RaceCode SQL_Latin1_General_CP1_CI_AS
120 SQLCHAR 2 5 "" 120 Borrower4RaceCode SQL_Latin1_General_CP1_CI_AS
121 SQLDATETIM4 1 4 "" 121 InterestAccrualDate ""
122 SQLCHAR 2 31 "" 122 BillingAddress SQL_Latin1_General_CP1_CI_AS
123 SQLCHAR 2 31 "" 123 BillingAddress2 SQL_Latin1_General_CP1_CI_AS
124 SQLCHAR 2 30 "" 124 BillingCity SQL_Latin1_General_CP1_CI_AS
125 SQLCHAR 2 2 "" 125 BillingState SQL_Latin1_General_CP1_CI_AS
126 SQLCHAR 2 5 "" 126 BillingZipCode SQL_Latin1_General_CP1_CI_AS
127 SQLCHAR 2 30 "" 127 BorrowerFirstName SQL_Latin1_General_CP1_CI_AS
128 SQLCHAR 2 9 "" 128 DecisionerRep SQL_Latin1_General_CP1_CI_AS
129 SQLCHAR 2 10 "" 129 InvestmentRepNumber SQL_Latin1_General_CP1_CI_AS
130 SQLCHAR 2 40 "" 130 InvestmentRepName SQL_Latin1_General_CP1_CI_AS
131 SQLDATETIM4 1 4 "" 131 StatusCodeDate ""
132 SQLDATETIM4 1 4 "" 132 FundingClearedDate ""
133 SQLDATETIM4 1 4 "" 133 ApprovalCondDate ""
134 SQLDATETIM4 1 4 "" 134 OrigSCLOPackageDate ""
135 SQLDATETIM4 1 4 "" 135 LastSCLOPackageDate ""
136 SQLCHAR 2 1 "" 136 ApprovalCondLatePmtInd SQL_Latin1_General_CP1_CI_AS
137 SQLCHAR 2 1 "" 137 ApprovalCondPmtHistInd SQL_Latin1_General_CP1_CI_AS
138 SQLCHAR 2 1 "" 138 ApprovalCondAlimonyInd SQL_Latin1_General_CP1_CI_AS
139 SQLCHAR 2 1 "" 139 ApprovalCondCAIVR SQL_Latin1_General_CP1_CI_AS
140 SQLCHAR 2 1 "" 140 ApprovalCondLDPGSA SQL_Latin1_General_CP1_CI_AS
141 SQLCHAR 2 8 "" 141 CreditRiskClass SQL_Latin1_General_CP1_CI_AS
142 SQLCHAR 2 15 "" 142 BorrowerHomePhone SQL_Latin1_General_CP1_CI_AS
143 SQLCHAR 2 15 "" 143 BorrowerWorkPhone SQL_Latin1_General_CP1_CI_AS
144 SQLCHAR 2 30 "" 144 SettlementAgent SQL_Latin1_General_CP1_CI_AS
145 SQLCHAR 2 20 "" 145 SettlementAgentAddress SQL_Latin1_General_CP1_CI_AS
146 SQLCHAR 2 20 "" 146 SettlementAgentCity SQL_Latin1_General_CP1_CI_AS
147 SQLCHAR 2 2 "" 147 SettlementAgentState SQL_Latin1_General_CP1_CI_AS
148 SQLCHAR 2 5 "" 148 SettlementAgentZip SQL_Latin1_General_CP1_CI_AS
149 SQLCHAR 2 10 "" 149 SettlementAgentPhone SQL_Latin1_General_CP1_CI_AS
150 SQLCHAR 2 10 "" 150 SettlementAgentFax SQL_Latin1_General_CP1_CI_AS
151 SQLCHAR 2 60 "" 151 SettlementAgentEMail SQL_Latin1_General_CP1_CI_AS
152 SQLCHAR 2 10 "" 152 UnderwriterID SQL_Latin1_General_CP1_CI_AS
153 SQLDATETIM4 1 4 "" 153 ScheduledToSignDate ""
154 SQLDATETIM4 1 4 "" 154 DisbursementDate ""
155 SQLDATETIM4 1 4 "" 155 ClosingHandOffDate ""
156 SQLINT 1 4 "" 156 AmortizationType ""
157 SQLDATETIM4 1 4 "" 157 FundsToArriveDate ""
158 SQLDATETIM4 1 4 "" 158 FirstPreApprovalDate ""
159 SQLDATETIM4 1 4 "" 159 FirstApprovalDate ""
160 SQLDATETIM4 1 4 "" 160 DecisionDate ""
161 SQLDATETIM4 1 4 "" 161 LoanToUnderwriterDate ""
162 SQLDATETIM4 1 4 "" 162 ApprovedWithPropertyDate ""
163 SQLDATETIM4 1 4 "" 163 LoanAtCloserDate ""
164 SQLDATETIM4 1 4 "" 164 LastLoanAtCloserDate ""
165 SQLDATETIM4 1 4 "" 165 LastFundsWiredDate ""
166 SQLDATETIM4 1 4 "" 166 OrigFundingConfirmedDate ""
167 SQLCHAR 2 2 "" 167 PropertyStatus SQL_Latin1_General_CP1_CI_AS
168 SQLCHAR 2 50 "" 168 ListingAgentName SQL_Latin1_General_CP1_CI_AS
169 SQLCHAR 2 40 "" 169 ListingAgentPhone SQL_Latin1_General_CP1_CI_AS
170 SQLCHAR 2 50 "" 170 SellingAgentName SQL_Latin1_General_CP1_CI_AS
171 SQLCHAR 2 40 "" 171 SellingAgentPhone SQL_Latin1_General_CP1_CI_AS
172 SQLCHAR 2 10 "" 172 ContactRealtorInd SQL_Latin1_General_CP1_CI_AS
173 SQLDATETIM4 1 4 "" 173 DisclosurePkgOrderedDate ""
174 SQLDATETIM4 1 4 "" 174 DisclosurePkgRecdDate ""
175 SQLDATETIM4 1 4 "" 175 DisclosurePkgComplianceDate ""
176 SQLCHAR 2 3 "" 176 DisclosurePkgRep SQL_Latin1_General_CP1_CI_AS
177 SQLDATETIM4 1 4 "" 177 CommitmentPktPrintedDate ""
178 SQLDATETIM4 1 4 "" 178 CommitmentPktSentDate ""
179 SQLDATETIM4 1 4 "" 179 CommitmentPktEntryDate ""
180 SQLCHAR 2 3 "" 180 CommitmentPktRep SQL_Latin1_General_CP1_CI_AS
181 SQLDATETIM4 1 4 "" 181 CounterOfferSentDate ""
182 SQLDATETIM4 1 4 "" 182 CounterOfferEntryDate ""
183 SQLCHAR 2 3 "" 183 CounterOfferRep SQL_Latin1_General_CP1_CI_AS
184 SQLCHAR 2 1 "" 184 FNMAJudgement SQL_Latin1_General_CP1_CI_AS
185 SQLCHAR 2 1 "" 185 FNMAForeclosure SQL_Latin1_General_CP1_CI_AS
186 SQLCHAR 2 1 "" 186 FNMAEndorser SQL_Latin1_General_CP1_CI_AS
187 SQLCHAR 2 1 "" 187 FNMAAlimony SQL_Latin1_General_CP1_CI_AS
188 SQLCHAR 2 1 "" 188 FNMADownPayment SQL_Latin1_General_CP1_CI_AS
189 SQLCHAR 2 1 "" 189 FNMALawSuit SQL_Latin1_General_CP1_CI_AS
190 SQLCHAR 2 1 "" 190 FNMABankruptcy SQL_Latin1_General_CP1_CI_AS
191 SQLCHAR 2 1 "" 191 FNMAObligations SQL_Latin1_General_CP1_CI_AS
192 SQLCHAR 2 1 "" 192 FNMADelinquency SQL_Latin1_General_CP1_CI_AS
193 SQLCHAR 2 1 "" 193 FNMAUSCitizen SQL_Latin1_General_CP1_CI_AS
194 SQLCHAR 2 1 "" 194 FNMAPermResAlien SQL_Latin1_General_CP1_CI_AS
195 SQLCHAR 2 1 "" 195 FNMAForeignNational SQL_Latin1_General_CP1_CI_AS
196 SQLCHAR 2 1 "" 196 FNMANonPermResAlien SQL_Latin1_General_CP1_CI_AS
197 SQLCHAR 2 1 "" 197 BorrSelfEmployedInd SQL_Latin1_General_CP1_CI_AS
198 SQLCHAR 2 30 "" 198 EmployerName SQL_Latin1_General_CP1_CI_AS
199 SQLCHAR 2 30 "" 199 EmployerCity SQL_Latin1_General_CP1_CI_AS
200 SQLCHAR 2 10 "" 200 EmployerState SQL_Latin1_General_CP1_CI_AS
201 SQLCHAR 2 10 "" 201 EmployerZipCode SQL_Latin1_General_CP1_CI_AS
202 SQLCHAR 2 10 "" 202 EmployerPhoneNumber SQL_Latin1_General_CP1_CI_AS
203 SQLDATETIM4 1 4 "" 203 PropertyNotificationDate ""
204 SQLDATETIM4 1 4 "" 204 PropertyNotificationEntryDate ""
205 SQLCHAR 2 3 "" 205 PropertyRepConv SQL_Latin1_General_CP1_CI_AS
206 SQLDATETIM4 1 4 "" 206 TitleReviewedDate ""
207 SQLCHAR 2 3 "" 207 TitleReviewedRep SQL_Latin1_General_CP1_CI_AS
208 SQLDATETIM4 1 4 "" 208 NotificationDate ""
209 SQLDATETIM4 1 4 "" 209 DenialCancelLetterPrintedDate ""
210 SQLCHAR 2 3 "" 210 DenialCancelLetterRep SQL_Latin1_General_CP1_CI_AS
211 SQLDATETIM4 1 4 "" 211 ClosingCostsCallDate ""
212 SQLDATETIM4 1 4 "" 212 ClosingCostsCallEntryDate ""
213 SQLCHAR 2 3 "" 213 ClosingCostsCallRep SQL_Latin1_General_CP1_CI_AS
214 SQLTINYINT 1 1 "" 214 PresentAddressYears ""
215 SQLTINYINT 1 1 "" 215 PresentAddressMonths ""
216 SQLDATETIM4 1 4 "" 216 EmployerStartDate ""
217 SQLCHAR 2 20 "" 217 PrevBorrowerAddress SQL_Latin1_General_CP1_CI_AS
218 SQLCHAR 2 18 "" 218 PrevBorrowerCity SQL_Latin1_General_CP1_CI_AS
219 SQLCHAR 2 2 "" 219 PrevBorrowerState SQL_Latin1_General_CP1_CI_AS
220 SQLCHAR 2 9 "" 220 PrevBorrowerZipCode SQL_Latin1_General_CP1_CI_AS
221 SQLTINYINT 1 1 "" 221 PrevAddressYears ""
222 SQLTINYINT 1 1 "" 222 PrevAddressMonths ""
223 SQLCHAR 2 25 "" 223 PrevEmployerName SQL_Latin1_General_CP1_CI_AS
224 SQLCHAR 2 30 "" 224 PrevEmployerCity SQL_Latin1_General_CP1_CI_AS
225 SQLCHAR 2 2 "" 225 PrevEmployerState SQL_Latin1_General_CP1_CI_AS
226 SQLDATETIM4 1 4 "" 226 PrevEmployerStartDate ""
227 SQLDECIMAL 1 19 "" 227 BorrowerIncomeBase ""
228 SQLDECIMAL 1 19 "" 228 BorrowerIncomeOT ""
229 SQLDECIMAL 1 19 "" 229 BorrowerIncomeBonus ""
230 SQLDECIMAL 1 19 "" 230 BorrowerIncomeComm ""
231 SQLDECIMAL 1 19 "" 231 BorrowerIncomeDividend ""
232 SQLCHAR 2 1 "" 232 BorrPrevSelfEmployedInd SQL_Latin1_General_CP1_CI_AS
233 SQLDATETIM4 1 4 "" 233 DocRqstLtrPrintedDate ""
234 SQLDATETIM4 1 4 "" 234 DocRqstLtrEntryDate ""
235 SQLCHAR 2 3 "" 235 DocRqstLtrRep SQL_Latin1_General_CP1_CI_AS
236 SQLDATETIM4 1 4 "" 236 LastCustomerContactDate ""
237 SQLDATETIM4 1 4 "" 237 AuthToCloseReceivedDate ""
238 SQLDATETIM4 1 4 "" 238 AuthToCloseEntryDate ""
239 SQLCHAR 2 3 "" 239 AuthToCloseRep SQL_Latin1_General_CP1_CI_AS
240 SQLDECIMAL 1 19 "" 240 BorrowerTotalAssets ""
241 SQLDECIMAL 1 19 "" 241 BorrowerTotalCashRequired ""
242 SQLCHAR 2 6 "" 242 SalesAU SQL_Latin1_General_CP1_CI_AS
243 SQLCHAR 2 6 "" 243 FulfillmentAU SQL_Latin1_General_CP1_CI_AS
244 SQLCHAR 2 1 "" 244 BusinessLineCode SQL_Latin1_General_CP1_CI_AS
245 SQLCHAR 2 1 "" 245 BusinessStructureCode SQL_Latin1_General_CP1_CI_AS
246 SQLCHAR 2 3 "" 246 BusinessTypeCode SQL_Latin1_General_CP1_CI_AS
247 SQLCHAR 2 3 "" 247 BusinessProgramCode SQL_Latin1_General_CP1_CI_AS
248 SQLDATETIM4 1 4 "" 248 AppTakenTime ""
249 SQLCHAR 2 6 "" 249 AppTakenMonth SQL_Latin1_General_CP1_CI_AS
250 SQLDATETIM4 1 4 "" 250 FundingTime ""
251 SQLCHAR 2 6 "" 251 FundingMonth SQL_Latin1_General_CP1_CI_AS
252 SQLCHAR 2 1 "" 252 CreditOnlyIndRaw SQL_Latin1_General_CP1_CI_AS
253 SQLCHAR 2 9 "" 253 borrower1ssn SQL_Latin1_General_CP1_CI_AS
254 SQLCHAR 2 9 "" 254 borrower2ssn SQL_Latin1_General_CP1_CI_AS
255 SQLCHAR 2 9 "" 255 borrower3ssn SQL_Latin1_General_CP1_CI_AS
256 SQLCHAR 2 9 "" 256 borrower4ssn SQL_Latin1_General_CP1_CI_AS
257 SQLCHAR 2 1 "" 257 ActionTaken SQL_Latin1_General_CP1_CI_AS
258 SQLCHAR 2 4 "" 258 MACode SQL_Latin1_General_CP1_CI_AS
259 SQLDATETIM4 1 4 "" 259 UploadDate ""
260 SQLDATETIM4 1 4 "" 260 UpdateDate ""
261 SQLDATETIM4 1 4 "" 261 FundingDateRaw ""
262 SQLCHAR 2 1 "" 262 Borrower1EthnicityCode SQL_Latin1_General_CP1_CI_AS
263 SQLCHAR 2 1 "" 263 Borrower2EthnicityCode SQL_Latin1_General_CP1_CI_AS
264 SQLCHAR 2 1 "" 264 Borrower3EthnicityCode SQL_Latin1_General_CP1_CI_AS
265 SQLCHAR 2 1 "" 265 Borrower4EthnicityCode SQL_Latin1_General_CP1_CI_AS
266 SQLCHAR 2 1 "" 266 Borrower1RaceCode2 SQL_Latin1_General_CP1_CI_AS
267 SQLCHAR 2 1 "" 267 Borrower2RaceCode2 SQL_Latin1_General_CP1_CI_AS
268 SQLCHAR 2 1 "" 268 Borrower3RaceCode2 SQL_Latin1_General_CP1_CI_AS
269 SQLCHAR 2 1 "" 269 Borrower4RaceCode2 SQL_Latin1_General_CP1_CI_AS
270 SQLCHAR 2 1 "" 270 Borrower1RaceCode3 SQL_Latin1_General_CP1_CI_AS
271 SQLCHAR 2 1 "" 271 Borrower2RaceCode3 SQL_Latin1_General_CP1_CI_AS
272 SQLCHAR 2 1 "" 272 Borrower3RaceCode3 SQL_Latin1_General_CP1_CI_AS
273 SQLCHAR 2 1 "" 273 Borrower4RaceCode3 SQL_Latin1_General_CP1_CI_AS
274 SQLCHAR 2 1 "" 274 Borrower1RaceCode4 SQL_Latin1_General_CP1_CI_AS
275 SQLCHAR 2 1 "" 275 Borrower2RaceCode4 SQL_Latin1_General_CP1_CI_AS
276 SQLCHAR 2 1 "" 276 Borrower3RaceCode4 SQL_Latin1_General_CP1_CI_AS
277 SQLCHAR 2 1 "" 277 Borrower4RaceCode4 SQL_Latin1_General_CP1_CI_AS
278 SQLCHAR 2 1 "" 278 Borrower1RaceCode5 SQL_Latin1_General_CP1_CI_AS
279 SQLCHAR 2 1 "" 279 Borrower2RaceCode5 SQL_Latin1_General_CP1_CI_AS
280 SQLCHAR 2 1 "" 280 Borrower3RaceCode5 SQL_Latin1_General_CP1_CI_AS
281 SQLCHAR 2 1 "" 281 Borrower4RaceCode5 SQL_Latin1_General_CP1_CI_AS
282 SQLCHAR 2 1 "" 282 Borrower1GenderCode SQL_Latin1_General_CP1_CI_AS
283 SQLCHAR 2 1 "" 283 Borrower2GenderCode SQL_Latin1_General_CP1_CI_AS
284 SQLCHAR 2 1 "" 284 Borrower3GenderCode SQL_Latin1_General_CP1_CI_AS
285 SQLCHAR 2 1 "" 285 Borrower4GenderCode SQL_Latin1_General_CP1_CI_AS
286 SQLCHAR 2 4 "" 286 ChannelCode SQL_Latin1_General_CP1_CI_AS
287 SQLCHAR 2 20 "" 287 PresBorrowerAddress SQL_Latin1_General_CP1_CI_AS
288 SQLCHAR 2 18 "" 288 PresBorrowerCity SQL_Latin1_General_CP1_CI_AS
289 SQLCHAR 2 2 "" 289 PresBorrowerState SQL_Latin1_General_CP1_CI_AS
290 SQLCHAR 2 9 "" 290 PresBorrowerZip SQL_Latin1_General_CP1_CI_AS
291 SQLDATETIM4 1 4 "" 291 ClosingPackageSentDate ""
292 SQLCHAR 2 14 "" 292 ReferralAU SQL_Latin1_General_CP1_CI_AS
293 SQLDATETIM4 1 4 "" 293 InterviewDate ""
294 SQLCHAR 2 1 "" 294 UploadInd SQL_Latin1_General_CP1_CI_AS
295 SQLCHAR 2 12 "" 295 FundingNumber SQL_Latin1_General_CP1_CI_AS
296 SQLDATETIM4 1 4 "" 296 EV1Other2RecdDate ""
297 SQLDATETIM4 1 4 "" 297 EV1Other2RqstDate ""
298 SQLCHAR 2 10 "" 298 HOITransferRep SQL_Latin1_General_CP1_CI_AS
299 SQLCHAR 2 10 "" 299 BranchCode SQL_Latin1_General_CP1_CI_AS
300 SQLDATETIM4 1 4 "" 300 FloodDetermineDate ""
301 SQLDATETIM4 1 4 "" 301 FloodDetermineOrderDate ""
302 SQLCHAR 2 1 "" 302 FloodRequiredInd SQL_Latin1_General_CP1_CI_AS
303 SQLDATETIM4 1 4 "" 303 MapRecDate ""
304 SQLDATETIM4 1 4 "" 304 ShippedDate ""
305 SQLDATETIM4 1 4 "" 305 LISUploadDate ""
306 SQLCHAR 2 1 "" 306 InitialStatus SQL_Latin1_General_CP1_CI_AS
307 SQLDATETIM4 1 4 "" 307 CCRCancelDate ""
308 SQLCHAR 2 1 "" 308 OMSInd SQL_Latin1_General_CP1_CI_AS
309 SQLCHAR 2 6 "" 309 OccupancyCode SQL_Latin1_General_CP1_CI_AS
310 SQLFLT8 1 8 "" 310 SalesPrice ""
311 SQLFLT8 1 8 "" 311 Margin ""
312 SQLDATETIM4 1 4 "" 312 ClosedDate ""
313 SQLDATETIM4 1 4 "" 313 OrigRateExpDate ""
314 SQLFLT8 1 8 "" 314 DeskPrice ""
315 SQLFLT8 1 8 "" 315 ChannelPrice ""
316 SQLFLT8 1 8 "" 316 PricingGroupPrice ""
317 SQLFLT8 1 8 "" 317 BusinessUnitPrice ""
318 SQLDATETIM4 1 4 "" 318 ATCReturnedDate ""
319 SQLDATETIM4 1 4 "" 319 ATCSentDate ""
320 SQLCHAR 2 6 "" 320 SalabilityCode SQL_Latin1_General_CP1_CI_AS
321 SQLCHAR 2 6 "" 321 CreditRejectedCode SQL_Latin1_General_CP1_CI_AS
322 SQLDATETIM4 1 4 "" 322 RDUploadDate ""
323 SQLDATETIM4 1 4 "" 323 WelcomeTrackingDate ""
324 SQLDATETIM4 1 4 "" 324 WelcomeDueDate ""
325 SQLDATETIM4 1 4 "" 325 WelcomeContactDate ""
326 SQLDATETIM4 1 4 "" 326 Ev2Other1DateRqstd ""
327 SQLDATETIM4 1 4 "" 327 Ev2Other2DateRqstd ""
328 SQLDATETIM4 1 4 "" 328 Ev2Other3DateRqstd ""
329 SQLCHAR 2 10 "" 329 PricingToolCode SQL_Latin1_General_CP1_CI_AS
330 SQLCHAR 2 10 "" 330 StageCoachPriority SQL_Latin1_General_CP1_CI_AS
331 SQLCHAR 2 25 "" 331 BuilderName SQL_Latin1_General_CP1_CI_AS
332 SQLDATETIM4 1 4 "" 332 SuspendedDate ""
333 SQLCHAR 2 3 "" 333 BankProductsRep SQL_Latin1_General_CP1_CI_AS
334 SQLDATETIM4 1 4 "" 334 HudFundsReceivedDate ""
335 SQLFLT8 1 8 "" 335 QuoteRate ""
336 SQLINT 1 4 "" 336 OrigRateLockPeriod ""
337 SQLDATETIME 1 8 "" 337 OrigRateLockDate ""
338 SQLCHAR 2 1 "" 338 PCAEligInd SQL_Latin1_General_CP1_CI_AS
339 SQLCHAR 2 1 "" 339 POSCode SQL_Latin1_General_CP1_CI_AS
340 SQLCHAR 2 6 "" 340 CentSalesAU SQL_Latin1_General_CP1_CI_AS
341 SQLCHAR 2 3 "" 341 CentSalesEntityNo SQL_Latin1_General_CP1_CI_AS
342 SQLCHAR 2 3 "" 342 FulfillmentEntityNo SQL_Latin1_General_CP1_CI_AS
343 SQLCHAR 2 3 "" 343 SalesEntityNo SQL_Latin1_General_CP1_CI_AS
344 SQLCHAR 2 3 "" 344 ReferralEntityNo SQL_Latin1_General_CP1_CI_AS
345 SQLDECIMAL 1 19 "" 345 BuydownTotalReqFundsAmt ""
346 SQLCHAR 2 6 "" 346 BuydownTypeCode SQL_Latin1_General_CP1_CI_AS
347 SQLCHAR 2 2 "" 347 BuydownPayer1Code SQL_Latin1_General_CP1_CI_AS
348 SQLDECIMAL 1 19 "" 348 BuydownPayer1Amt ""
349 SQLCHAR 2 2 "" 349 BuydownPayer2Code SQL_Latin1_General_CP1_CI_AS
350 SQLDECIMAL 1 19 "" 350 BuydownPayer2Amt ""
351 SQLDATETIME 1 8 "" 351 AIRLDocsRecvDate ""
352 SQLDATETIME 1 8 "" 352 AIRLLetterDate ""
353 SQLCHAR 2 1 "" 353 BrokeredInInd SQL_Latin1_General_CP1_CI_AS
354 SQLCHAR 2 1 "" 354 BrokeredOutInd SQL_Latin1_General_CP1_CI_AS
355 SQLDECIMAL 1 19 "" 355 Buydown1Amt ""
356 SQLDECIMAL 1 19 "" 356 Buydown2Amt ""
357 SQLDECIMAL 1 19 "" 357 Buydown3Amt ""
358 SQLDECIMAL 1 19 "" 358 Buydown4Amt ""
359 SQLDECIMAL 1 19 "" 359 Buydown5Amt ""
360 SQLDECIMAL 1 19 "" 360 Buydown6Amt ""
361 SQLDECIMAL 1 19 "" 361 Buydown7Amt ""
362 SQLDECIMAL 1 19 "" 362 Buydown8Amt ""
363 SQLDECIMAL 1 19 "" 363 Buydown9Amt ""
364 SQLDECIMAL 1 19 "" 364 Buydown10Amt ""
365 SQLINT 1 4 "" 365 Buydown1MonthsQty ""
366 SQLINT 1 4 "" 366 Buydown2MonthsQty ""
367 SQLINT 1 4 "" 367 Buydown3MonthsQty ""
368 SQLINT 1 4 "" 368 Buydown4MonthsQty ""
369 SQLINT 1 4 "" 369 Buydown5MonthsQty ""
370 SQLINT 1 4 "" 370 Buydown6MonthsQty ""
371 SQLINT 1 4 "" 371 Buydown7MonthsQty ""
372 SQLINT 1 4 "" 372 Buydown8MonthsQty ""
373 SQLINT 1 4 "" 373 Buydown9MonthsQty ""
374 SQLINT 1 4 "" 374 Buydown10MonthsQty ""
375 SQLINT 1 4 "" 375 BuildYear ""
376 SQLCHAR 2 3 "" 376 PropertyClassCode SQL_Latin1_General_CP1_CI_AS
377 SQLDECIMAL 1 19 "" 377 BuydownLenderAmtRaw ""
378 SQLCHAR 2 1 "" 378 BuydownLenderAmtTypeCode SQL_Latin1_General_CP1_CI_AS
379 SQLDECIMAL 1 19 "" 379 BuydownSellerAmtRaw ""
380 SQLCHAR 2 1 "" 380 BuydownSellerAmtTypeCode SQL_Latin1_General_CP1_CI_AS
381 SQLDATETIME 1 8 "" 381 Borr1CreditRecvDate ""
382 SQLDATETIME 1 8 "" 382 CommitLetterSentDate ""
383 SQLDATETIME 1 8 "" 383 FSReceiptDate ""
384 SQLDATETIME 1 8 "" 384 RMCPkgRecvDate ""
385 SQLCHAR 2 1 "" 385 CreditRefusedInd SQL_Latin1_General_CP1_CI_AS
386 SQLCHAR 2 1 "" 386 LoanCancelledInd SQL_Latin1_General_CP1_CI_AS
387 SQLCHAR 2 1 "" 387 CounterOfferRejectedInd SQL_Latin1_General_CP1_CI_AS
388 SQLCHAR 2 30 "" 388 Borr2FirstName SQL_Latin1_General_CP1_CI_AS
389 SQLCHAR 2 30 "" 389 Borr2LastName SQL_Latin1_General_CP1_CI_AS
390 SQLCHAR 2 31 "" 390 Borr2Address SQL_Latin1_General_CP1_CI_AS
391 SQLCHAR 2 31 "" 391 Borr2Address2 SQL_Latin1_General_CP1_CI_AS
392 SQLCHAR 2 30 "" 392 Borr2CityName SQL_Latin1_General_CP1_CI_AS
393 SQLCHAR 2 2 "" 393 Borr2StateCode SQL_Latin1_General_CP1_CI_AS
394 SQLCHAR 2 10 "" 394 Borr2ZipCode SQL_Latin1_General_CP1_CI_AS
395 SQLCHAR 2 30 "" 395 Borr3FirstName SQL_Latin1_General_CP1_CI_AS
396 SQLCHAR 2 30 "" 396 Borr3LastName SQL_Latin1_General_CP1_CI_AS
397 SQLCHAR 2 30 "" 397 Borr4FirstName SQL_Latin1_General_CP1_CI_AS
398 SQLCHAR 2 30 "" 398 Borr4LastName SQL_Latin1_General_CP1_CI_AS
399 SQLDATETIME 1 8 "" 399 AdverseActionSentDate ""
400 SQLDATETIME 1 8 "" 400 NOCSentDate ""
401 SQLDATETIME 1 8 "" 401 Borr2CreditReceivedDate ""
402 SQLDATETIME 1 8 "" 402 Borr3CreditReceivedDate ""
403 SQLDATETIME 1 8 "" 403 Borr4CreditReceivedDate ""
404 SQLDATETIME 1 8 "" 404 CDDPkgSentDate ""
405 SQLDATETIME 1 8 "" 405 WelcomeLetterSendDate ""
406 SQLDATETIME 1 8 "" 406 WithdrawalSubmitDate ""
407 SQLCHAR 2 1 "" 407 ReverseInd SQL_Latin1_General_CP1_CI_AS
408 SQLCHAR 2 7 "" 408 ReferringEmployeeID SQL_Latin1_General_CP1_CI_AS
409 SQLDATETIME 1 8 "" 409 OrigAIRLLetterPrintDate ""
410 SQLCHAR 2 1 "" 410 FTHBInd SQL_Latin1_General_CP1_CI_AS
411 SQLCHAR 2 1 "" 411 InvestmentPropertyInd SQL_Latin1_General_CP1_CI_AS
412 SQLCHAR 2 1 "" 412 PrincipalResidenceInd SQL_Latin1_General_CP1_CI_AS
413 SQLCHAR 2 1 "" 413 SecondHomeInd SQL_Latin1_General_CP1_CI_AS
414 SQLCHAR 2 1 "" 414 RentOwnStatusCode SQL_Latin1_General_CP1_CI_AS
415 SQLDECIMAL 1 19 "" 415 CLTV ""
416 SQLDECIMAL 1 19 "" 416 DebtToIncomeRatio ""
417 SQLCHAR 2 25 "" 417 ClosingAgentName SQL_Latin1_General_CP1_CI_AS
418 SQLCHAR 2 3 "" 418 AppraisalVendorName SQL_Latin1_General_CP1_CI_AS
419 SQLCHAR 2 1 "" 419 SLRInitialDecisionCode SQL_Latin1_General_CP1_CI_AS
420 SQLDATETIME 1 8 "" 420 SLRInitialDecisionDate ""
421 SQLCHAR 2 3 "" 421 SLRInitialDecisionRep SQL_Latin1_General_CP1_CI_AS
422 SQLCHAR 2 8 "" 422 SLRInitialDenialReasonCode SQL_Latin1_General_CP1_CI_AS
423 SQLDATETIME 1 8 "" 423 NDSFileSentDate ""
424 SQLDATETIME 1 8 "" 424 NDSFileRecvDate ""
425 SQLCHAR 2 1 "" 425 SLRFinalDecisionCode SQL_Latin1_General_CP1_CI_AS
426 SQLDATETIME 1 8 "" 426 SLRFinalDecisionDate ""
427 SQLCHAR 2 3 "" 427 SLRFinalDecisionRep SQL_Latin1_General_CP1_CI_AS
428 SQLCHAR 2 8 "" 428 SLRFinalDenialReasonCode SQL_Latin1_General_CP1_CI_AS
429 SQLDATETIME 1 8 "" 429 NDSFileReleaseDate ""
430 SQLDATETIME 1 8 "" 430 HazardInsLastCallDate ""
431 SQLDATETIME 1 8 "" 431 HazardInsLastNextDate ""
432 SQLCHAR 2 1 "" 432 HazardInsVerifiedInd SQL_Latin1_General_CP1_CI_AS
433 SQLCHAR 2 1 "" 433 NetFundedInd SQL_Latin1_General_CP1_CI_AS
434 SQLDATETIME 1 8 "" 434 PrelimHUD1OrdDate ""
435 SQLDATETIME 1 8 "" 435 PrelimHUD1RecvDate ""
436 SQLINT 1 4 "" 436 BorrCount ""
437 SQLCHAR 2 50 "" 437 ActionTakenName SQL_Latin1_General_CP1_CI_AS
438 SQLCHAR 2 2 "" 438 Borr1OwnerIntTypeCode SQL_Latin1_General_CP1_CI_AS
439 SQLCHAR 2 2 "" 439 Borr2OwnerIntTypeCode SQL_Latin1_General_CP1_CI_AS
440 SQLCHAR 2 1 "" 440 Borr1PresAddrOwnInd SQL_Latin1_General_CP1_CI_AS
441 SQLCHAR 2 1 "" 441 Borr2PresAddrOwnInd SQL_Latin1_General_CP1_CI_AS
442 SQLCHAR 2 1 "" 442 Borr3PresAddrOwnInd SQL_Latin1_General_CP1_CI_AS
443 SQLCHAR 2 1 "" 443 Borr4PresAddrOwnInd SQL_Latin1_General_CP1_CI_AS
444 SQLCHAR 2 1 "" 444 Borr1PresAddrRentInd SQL_Latin1_General_CP1_CI_AS
445 SQLCHAR 2 1 "" 445 Borr2PresAddrRentInd SQL_Latin1_General_CP1_CI_AS
446 SQLCHAR 2 1 "" 446 Borr3PresAddrRentInd SQL_Latin1_General_CP1_CI_AS
447 SQLCHAR 2 1 "" 447 Borr4PresAddrRentInd SQL_Latin1_General_CP1_CI_AS
448 SQLCHAR 2 1 "" 448 Borr1PrevAddr1OwnInd SQL_Latin1_General_CP1_CI_AS
449 SQLCHAR 2 1 "" 449 Borr2PrevAddr1OwnInd SQL_Latin1_General_CP1_CI_AS
450 SQLCHAR 2 1 "" 450 Borr3PrevAddr1OwnInd SQL_Latin1_General_CP1_CI_AS
451 SQLCHAR 2 1 "" 451 Borr4PrevAddr1OwnInd SQL_Latin1_General_CP1_CI_AS
452 SQLCHAR 2 1 "" 452 Borr1PrevAddr1RentInd SQL_Latin1_General_CP1_CI_AS
453 SQLCHAR 2 1 "" 453 Borr2PrevAddr1RentInd SQL_Latin1_General_CP1_CI_AS
454 SQLCHAR 2 1 "" 454 Borr3PrevAddr1RentInd SQL_Latin1_General_CP1_CI_AS
455 SQLCHAR 2 1 "" 455 Borr4PrevAddr1RentInd SQL_Latin1_General_CP1_CI_AS
456 SQLCHAR 2 1 "" 456 Borr1PrevAddr2OwnInd SQL_Latin1_General_CP1_CI_AS
457 SQLCHAR 2 1 "" 457 Borr2PrevAddr2OwnInd SQL_Latin1_General_CP1_CI_AS
458 SQLCHAR 2 1 "" 458 Borr3PrevAddr2OwnInd SQL_Latin1_General_CP1_CI_AS
459 SQLCHAR 2 1 "" 459 Borr4PrevAddr2OwnInd SQL_Latin1_General_CP1_CI_AS
460 SQLCHAR 2 1 "" 460 Borr1PrevAddr2RentInd SQL_Latin1_General_CP1_CI_AS
461 SQLCHAR 2 1 "" 461 Borr2PrevAddr2RentInd SQL_Latin1_General_CP1_CI_AS
462 SQLCHAR 2 1 "" 462 Borr3PrevAddr2RentInd SQL_Latin1_General_CP1_CI_AS
463 SQLCHAR 2 1 "" 463 Borr4PrevAddr2RentInd SQL_Latin1_General_CP1_CI_AS
464 SQLCHAR 2 1 "" 464 SuspenseReason1Code SQL_Latin1_General_CP1_CI_AS
465 SQLCHAR 2 1 "" 465 SuspenseReason2Code SQL_Latin1_General_CP1_CI_AS
466 SQLCHAR 2 1 "" 466 Borr1PresAddrRentOwnCode SQL_Latin1_General_CP1_CI_AS
467 SQLCHAR 2 1 "" 467 Borr2PresAddrRentOwnCode SQL_Latin1_General_CP1_CI_AS
468 SQLCHAR 2 1 "" 468 Borr3PresAddrRentOwnCode SQL_Latin1_General_CP1_CI_AS
469 SQLCHAR 2 1 "" 469 Borr4PresAddrRentOwnCode SQL_Latin1_General_CP1_CI_AS
470 SQLCHAR 2 1 "" 470 Borr1PrevAddr1RentOwnCode SQL_Latin1_General_CP1_CI_AS
471 SQLCHAR 2 1 "" 471 Borr2PrevAddr1RentOwnCode SQL_Latin1_General_CP1_CI_AS
472 SQLCHAR 2 1 "" 472 Borr3PrevAddr1RentOwnCode SQL_Latin1_General_CP1_CI_AS
473 SQLCHAR 2 1 "" 473 Borr4PrevAddr1RentOwnCode SQL_Latin1_General_CP1_CI_AS
474 SQLCHAR 2 1 "" 474 Borr1PrevAddr2RentOwnCode SQL_Latin1_General_CP1_CI_AS
475 SQLCHAR 2 1 "" 475 Borr2PrevAddr2RentOwnCode SQL_Latin1_General_CP1_CI_AS
476 SQLCHAR 2 1 "" 476 Borr3PrevAddr2RentOwnCode SQL_Latin1_General_CP1_CI_AS
477 SQLCHAR 2 1 "" 477 Borr4PrevAddr2RentOwnCode SQL_Latin1_General_CP1_CI_AS
478 SQLCHAR 2 7 "" 478 CoopProjectID SQL_Latin1_General_CP1_CI_AS
479 SQLCHAR 2 19 "" 479 UWReviewLevelCode SQL_Latin1_General_CP1_CI_AS
480 SQLDATETIME 1 8 "" 480 RMCPkgRequestDate ""
481 SQLDATETIM4 1 4 "" 481 LastRetractedFundingDate ""
482 SQLCHAR 2 14 "" 482 FloodInsCertNbr SQL_Latin1_General_CP1_CI_AS
483 SQLCHAR 2 50 "" 483 ListingAgentCompanyName SQL_Latin1_General_CP1_CI_AS
484 SQLCHAR 2 50 "" 484 SellingAgentCompanyName SQL_Latin1_General_CP1_CI_AS
485 SQLCHAR 2 1 "" 485 ClosingDateGuaranteeInd SQL_Latin1_General_CP1_CI_AS
486 SQLDATETIME 1 8 "" 486 InitialClosingDate ""
487 SQLDECIMAL 1 19 "" 487 OverdisbursedAmt ""
488 SQLDATETIME 1 8 "" 488 ClosingCostsCallRecvDate ""
489 SQLCHAR 2 1 "" 489 DebtConsolidationInd SQL_Latin1_General_CP1_CI_AS
490 SQLSMALLINT 1 2 "" 490 LatePaymentCount ""
491 SQLSMALLINT 1 2 "" 491 LatePaymentDayCount ""
492 SQLINT 1 4 "" 492 LeadRepStaffIndividualID ""
493 SQLINT 1 4 "" 493 ConvRepStaffIndividualID ""
494 SQLDATETIME 1 8 "" 494 CreditExpirationDate ""
495 SQLCHAR 2 30 "" 495 BankRepName SQL_Latin1_General_CP1_CI_AS
496 SQLCHAR 2 1 "" 496 MaritalStatusCode SQL_Latin1_General_CP1_CI_AS
497 SQLDATETIME 1 8 "" 497 POSLetterSentDate ""
498 SQLCHAR 2 60 "" 498 ReferringHMCEmail SQL_Latin1_General_CP1_CI_AS
499 SQLDATETIME 1 8 "" 499 Borr1BirthDate ""
500 SQLDATETIME 1 8 "" 500 Borr2BirthDate ""
501 SQLSMALLINT 1 2 "" 501 PTCOutstandingCondCount ""
502 SQLSMALLINT 1 2 "" 502 ATFOutstandingCondCount ""
503 SQLSMALLINT 1 2 "" 503 ATCOutstandingCondCount ""
504 SQLCHAR 2 60 "" 504 HMCEmailAddress SQL_Latin1_General_CP1_CI_AS

BCP delimiters

Howdy,
I have a fmt file used for importing data from a IBM database into SQL.
Currently we're using the pipe | as a delimiter and it works great. We need
to use another delimiter and I'm wondering if we can use multiple characters
like %$. If so, is it just as easy as changing the delimiter in the fmt
file?
Thanks,
David Lozzi
Hi David
"David Lozzi" wrote:

> Howdy,
> I have a fmt file used for importing data from a IBM database into SQL.
> Currently we're using the pipe | as a delimiter and it works great. We need
> to use another delimiter and I'm wondering if we can use multiple characters
> like %$. If so, is it just as easy as changing the delimiter in the fmt
> file?
> Thanks,
> David Lozzi
>
The field terminator can be a string of up to 10 printable characters. See
http://msdn2.microsoft.com/en-us/library/aa173859(SQL.80).aspx and
http://msdn2.microsoft.com/en-us/library/aa196735(SQL.80).aspx. The format
file is a text file so it can be edited with any text editor.
John
|||My b, did I mention its SQL 7? Does that change anything?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:D91F9576-9BFD-49DD-ABA6-1170B8B03CAA@.microsoft.com...
> Hi David
> "David Lozzi" wrote:
> The field terminator can be a string of up to 10 printable characters. See
> http://msdn2.microsoft.com/en-us/library/aa173859(SQL.80).aspx and
> http://msdn2.microsoft.com/en-us/library/aa196735(SQL.80).aspx. The format
> file is a text file so it can be edited with any text editor.
> John
|||Hi David
"David Lozzi" wrote:

> My b, did I mention its SQL 7? Does that change anything?
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:D91F9576-9BFD-49DD-ABA6-1170B8B03CAA@.microsoft.com...
>
I don't have a SQL 7 system to check, but you may want to look up BCP in
books online.
John

BCP delimiters

Howdy,
I have a fmt file used for importing data from a IBM database into SQL.
Currently we're using the pipe | as a delimiter and it works great. We need
to use another delimiter and I'm wondering if we can use multiple characters
like %$. If so, is it just as easy as changing the delimiter in the fmt
file?
Thanks,
David LozziHi David
"David Lozzi" wrote:

> Howdy,
> I have a fmt file used for importing data from a IBM database into SQL.
> Currently we're using the pipe | as a delimiter and it works great. We nee
d
> to use another delimiter and I'm wondering if we can use multiple characte
rs
> like %$. If so, is it just as easy as changing the delimiter in the fmt
> file?
> Thanks,
> David Lozzi
>
The field terminator can be a string of up to 10 printable characters. See
http://msdn2.microsoft.com/en-us/library/aa173859(SQL.80).aspx and
http://msdn2.microsoft.com/en-us/library/aa196735(SQL.80).aspx. The format
file is a text file so it can be edited with any text editor.
John|||My b, did I mention its SQL 7? Does that change anything?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:D91F9576-9BFD-49DD-ABA6-1170B8B03CAA@.microsoft.com...
> Hi David
> "David Lozzi" wrote:
>
> The field terminator can be a string of up to 10 printable characters. See
> http://msdn2.microsoft.com/en-us/library/aa173859(SQL.80).aspx and
> http://msdn2.microsoft.com/en-us/library/aa196735(SQL.80).aspx. The format
> file is a text file so it can be edited with any text editor.
> John|||Hi David
"David Lozzi" wrote:

> My b, did I mention its SQL 7? Does that change anything?
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:D91F9576-9BFD-49DD-ABA6-1170B8B03CAA@.microsoft.com...
>
I don't have a SQL 7 system to check, but you may want to look up BCP in
books online.
John

BCP delimiters

Howdy,
I have a fmt file used for importing data from a IBM database into SQL.
Currently we're using the pipe | as a delimiter and it works great. We need
to use another delimiter and I'm wondering if we can use multiple characters
like %$. If so, is it just as easy as changing the delimiter in the fmt
file?
Thanks,
David LozziHi David
"David Lozzi" wrote:
> Howdy,
> I have a fmt file used for importing data from a IBM database into SQL.
> Currently we're using the pipe | as a delimiter and it works great. We need
> to use another delimiter and I'm wondering if we can use multiple characters
> like %$. If so, is it just as easy as changing the delimiter in the fmt
> file?
> Thanks,
> David Lozzi
>
The field terminator can be a string of up to 10 printable characters. See
http://msdn2.microsoft.com/en-us/library/aa173859(SQL.80).aspx and
http://msdn2.microsoft.com/en-us/library/aa196735(SQL.80).aspx. The format
file is a text file so it can be edited with any text editor.
John|||My b, did I mention its SQL 7? Does that change anything?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:D91F9576-9BFD-49DD-ABA6-1170B8B03CAA@.microsoft.com...
> Hi David
> "David Lozzi" wrote:
>> Howdy,
>> I have a fmt file used for importing data from a IBM database into SQL.
>> Currently we're using the pipe | as a delimiter and it works great. We
>> need
>> to use another delimiter and I'm wondering if we can use multiple
>> characters
>> like %$. If so, is it just as easy as changing the delimiter in the fmt
>> file?
>> Thanks,
>> David Lozzi
> The field terminator can be a string of up to 10 printable characters. See
> http://msdn2.microsoft.com/en-us/library/aa173859(SQL.80).aspx and
> http://msdn2.microsoft.com/en-us/library/aa196735(SQL.80).aspx. The format
> file is a text file so it can be edited with any text editor.
> John|||Hi David
"David Lozzi" wrote:
> My b, did I mention its SQL 7? Does that change anything?
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:D91F9576-9BFD-49DD-ABA6-1170B8B03CAA@.microsoft.com...
> > Hi David
> >
> > "David Lozzi" wrote:
> >
> >> Howdy,
> >>
> >> I have a fmt file used for importing data from a IBM database into SQL.
> >> Currently we're using the pipe | as a delimiter and it works great. We
> >> need
> >> to use another delimiter and I'm wondering if we can use multiple
> >> characters
> >> like %$. If so, is it just as easy as changing the delimiter in the fmt
> >> file?
> >>
> >> Thanks,
> >>
> >> David Lozzi
> >>
> > The field terminator can be a string of up to 10 printable characters. See
> > http://msdn2.microsoft.com/en-us/library/aa173859(SQL.80).aspx and
> > http://msdn2.microsoft.com/en-us/library/aa196735(SQL.80).aspx. The format
> > file is a text file so it can be edited with any text editor.
> >
> > John
>
I don't have a SQL 7 system to check, but you may want to look up BCP in
books online.
John

bcp data importing error when using xml format file

Hello, I have a question.

I'm performing some early test for bulk import/export using the bcp(9.0) utility, but there is a problem when working with an xml FormatFile. I execute the following command:

>bcp TestDB.dbo.myNewTable1 in myDataFile.dat -fmyXMLFormatFile.xml -SmySever

-UmyAccount -PmyPassword

And get the following error:

Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file

0 rows copied.

Please help me understand and fix this problem.

Thanks a lot! Best regards,
Diego Valdez

For XML format you suppose to use -x switch...

Please check BOL for more info.

-x

Used with the format and -f format_file options, generates an XML-based format file instead of the default non-XML format file. The -x does not work when importing or exporting data. It generates an error if used without both format and -f format_file.

|||I don't think you understood my post...
My problem is not in the generated xml format file. This file was created succesfully. The issue arises when I try to import data with my specified bcp command and seems that there is something wrong with the Data File, as the message I get says "Unexpected EOF encountered in BCP data-file"
Hope someone can help me get around this.|||There maybe a problem with the data file but you need to get BCP to read your format file first as it could be a spurious error thats getting thrown, right now your commandline is not valid.

BCP connection problem

Hi,
I am trying to use BCP for bulk importing data into the SQL-server. I
created a system DSN that works fine with MS-Query, but bcp keeps returning
an error:
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
SQLState = 01000, NativeError = 53
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Can anybody tell me what's wrong here (or offer an alternative for bulk
importing data)?
thanks in advance, Hans
Hans,
What is the full command that you are using to bcp in your data? There
may be a problem with the bcp syntax that you are using and not with the
DSN.
Thanks,
JD
"Hans" <Hans@.discussions.microsoft.com> wrote in message
news:B0315ACB-43DF-4663-B9C1-9460BA7208DE@.microsoft.com...
> Hi,
> I am trying to use BCP for bulk importing data into the SQL-server. I
> created a system DSN that works fine with MS-Query, but bcp keeps
returning
> an error:
> SQLState = 08001, NativeError = 17
> Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
> exist or access denied.
> SQLState = 01000, NativeError = 53
> Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> (Connect()).
> Can anybody tell me what's wrong here (or offer an alternative for bulk
> importing data)?
> thanks in advance, Hans

bcp accent problem

Hello,
I'm importing data from formatted text files with accent (Latin1). My
database is set to French_CI_AS. I use bcp with -C"Latin1" or
-C"French_CI_AS" but bcp seems to ignore the flag and every single accent is
left behind.
That is if on column is "rené" in the source file, it becomes "ren" in the
database.
From experience, the -C flag should fix that problem but here nothing seems
to work.
Any ideas anyone?
Thanks,
Sitar.
Sitar (Sitar@.discussions.microsoft.com) writes:
> I'm importing data from formatted text files with accent (Latin1). My
> database is set to French_CI_AS. I use bcp with -C"Latin1" or
> -C"French_CI_AS" but bcp seems to ignore the flag and every single
> accent is left behind.
> That is if on column is "ren" in the source file, it becomes "ren" in the
> database.
> From experience, the -C flag should fix that problem but here nothing
> seems to work.
For -C you specify a code page, not a collation, as I recall. Thus, if the
file is in the ANSI code page, specify -C ANSI or -C RAW.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||Hi Erland,
Actually when I use bcp directly it works with either ANSI or Latin1. But
when I use a bcp format file it just stops working properly.
-- Sitar
"Erland Sommarskog" wrote:

> For -C you specify a code page, not a collation, as I recall. Thus, if the
> file is in the ANSI code page, specify -C ANSI or -C RAW.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx
>
|||Sitar (Sitar@.discussions.microsoft.com) writes:
> Actually when I use bcp directly it works with either ANSI or Latin1. But
> when I use a bcp format file it just stops working properly.
So how does the format file look like? Do you explicitly specify the
collation in it?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||The bcp format file looks like this:
8.0
11
1 SQLCHAR 0 0 "" 0
NUM_SEQ_SERVICE ""
2 SQLCHAR 0 6 ";" 2
CODE_ETABL_ID French_CI_AS
3 SQLCHAR 0 35 ";" 4
LIBELLE_ETABL French_CI_AS
4 SQLCHAR 0 4 ";" 5
CODE_CATEG_ETABL French_CI_AS
5 SQLCHAR 0 2 ";" 3
CODE_REGION_ID French_CI_AS
6 SQLCHAR 0 24 ";" 6
DATE_DEBUT ""
7 SQLCHAR 0 24 "\r\n" 7
DATE_FIN ""
8 SQLCHAR 0 0 "" 0
OCCURRENCE_PREVALIDEE ""
9 SQLCHAR 0 0 "" 0
ETAT_OCCURRENCE French_CI_AS
10 SQLCHAR 0 0 "" 0
OCCURRENCE_ACTIVEE ""
11 SQLCHAR 0 0 "" 0
DER_DATE_SAISIE ""
I tried with ANSI and RAW but it just does not do anything.
Sitar
___
"Erland Sommarskog" wrote:

> Sitar (Sitar@.discussions.microsoft.com) writes:
> So how does the format file look like? Do you explicitly specify the
> collation in it?
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx
>
|||Actually if I execute that commands from the server itself it works fine.
The problem occurs when I execute the command from another machine. More
specifically the IIS machine.
Sitar
"Erland Sommarskog" wrote:

> Sitar (Sitar@.discussions.microsoft.com) writes:
> So how does the format file look like? Do you explicitly specify the
> collation in it?
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx
>
|||Sitar (Sitar@.discussions.microsoft.com) writes:
> Actually if I execute that commands from the server itself it works fine.
> The problem occurs when I execute the command from another machine. More
> specifically the IIS machine.
And the regional settings of that machine is French?
Do you lose the accents, when run from a command-line window on the IIS
server? Or only when you run from within IIS?
Could you post the CREATE TABLE statement for the table, and some piece
of sample data? It's good if you can pack into a zip file, to prevent
that data get mashed in news transport.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||
> And the regional settings of that machine is French?
Both the IIS server and SQL Server machines' regional settings are french.

> Do you lose the accents, when run from a command-line window on the IIS
> server? Or only when you run from within IIS?
Actually I haven't tried yet from a command-line window on the IIS server. I
tried from SQL Query Analyzer on my dev machine and it works fine, providing
the format files and data files are hosted on the sql server. Otherwise the
accents are dropped.
I'll try on the IIS server.

> Could you post the CREATE TABLE statement for the table, and some piece
> of sample data? It's good if you can pack into a zip file, to prevent
> that data get mashed in news transport.
Not sure if I I'm allowed to post actual data but I'll see what I can do.
- Sitar
|||Sitar (Sitar@.discussions.microsoft.com) writes:
> Actually I haven't tried yet from a command-line window on the IIS
> server. I tried from SQL Query Analyzer on my dev machine and it works
> fine, providing the format files and data files are hosted on the sql
> server. Otherwise the accents are dropped.
This sounds funny. Did exactly say how you run the BCP command. You
tried from Query Analyzer. This is not from where I run my command-line
tools. Does this mean that you run BCP through xp_cmdshell? Or are you
in fact using BULK INSERT?

> Not sure if I I'm allowed to post actual data but I'll see what I can do.
It does not have to be actual data. Just make up some dummy data
that demonstrates the problem.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||Hi,
Sorry I haven't been specific enough.
I ran bcp both from a dos prompt and also from the Query Analyzer with the
bulk import command. With the bulk import command both the data file and the
format file were stored on the SQL server.
The problem seems to occur only when the data files and format files are
stored on another machine than the Sql Server.
So I suspect somewhere between the client and the sql server the data may
get corrupted or converted to an from an english locale and the accent could
be dropped. But I'm not sure why this would be happening.
- Sitar

> This sounds funny. Did exactly say how you run the BCP command. You
> tried from Query Analyzer. This is not from where I run my command-line
> tools. Does this mean that you run BCP through xp_cmdshell? Or are you
> in fact using BULK INSERT?
>
> It does not have to be actual data. Just make up some dummy data
> that demonstrates the problem.