bulk insert - crazy int values

[NewsBot]

Hi,

Im having some issues with BULK INSERT.
The table only has two columns, one INT and one VARCHAR column.

The table:
CREATETABLE [dbo].[GA_status](
[GA_recno] [int] NOTNULL,
[GA_desc] [varchar](40)NULL)

The data file (UTF-8):
1|10848|
2|10849|
3|12611|
4|10102|
5|10137|
6|12693|
7|10149|
8|12712|

The format file:
8.0
2
1**SQLINT**0**4***"|"**1**GA_recno*""
2**SQLCHAR**0**40***"|"**2**GA_desc*SQL_Latin1_General_CP1_CI_AS


The SQL:
BULKINSERT tmp_GA_status FROM'C:\temp\TextDump\MSSQL\GA_status.dta'WITH(FORMATFILE='C:\temp\TextDump\MSSQL\GA_status.fmt',DATAFILETYPE='char',ROWTERMINATOR='\n\r')


Okei so far so good. The sql runs and insert 8 rows, but the int values are different from the data file.
This is the result after insert:

GA_recno******GA_desc
834649071***10848
3279373******10849
3344909******12611
3410445******10102
3475981******10137
3541517******12693
3607053******10149
3672589******12712


Any ideas on how to fix it ??


More...

View All Our Microsoft Related Feeds