SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Data Format Issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bcomeau1986
Starting Member

1 Posts

Posted - 12/18/2012 :  22:39:42  Show Profile  Reply with Quote
Hi all,

I'm importing data in the following format:

1/1/2007 0:00:00;135;6006081;42.00;176400.00
1/1/2007 0:00:00;135;1113017;18.00;82800.00

My error is:

Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 5 (dblS).

My fields are:

[dtDate] [datetime] NULL,
[intRestId] [int] NULL,
[intProdId] [int] NULL,
[dblQ] [numeric] (18,0) Null,
[dblS] [numeric] (18,0) Null,
[dblP] [numeric] (18,0) Null

My Terminators are:

FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'

Any insights?

Thanks,
Brian

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 12/19/2012 :  09:45:33  Show Profile  Reply with Quote
You have six columns in your table, but only five in the data. Drop the last column (or change the data so there is a sixth column as shown below)
1/1/2007 0:00:00;135;6006081;42.00;176400.00;
1/1/2007 0:00:00;135;1113017;18.00;82800.00;
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000