Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Bulk insert task fails, BUT actually succeeds ? Expand / Collapse
Author
Message
Posted Tuesday, October 29, 2013 5:19 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:51 PM
Points: 183, Visits: 480
I made a simple bulk task to load data from a 3-4 kb csv (.txt) file. All the data is loaded correctly and yet SSIS shows that its failed. I don't get it. Why ?

The so-called error is -

[Bulk Insert Task] Error: An error occurred with the following error message: "Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (My_ID).".

I am using SSIS 2008 and SQL server 2008 for this one.

Post #1509614
Posted Tuesday, October 29, 2013 5:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:51 PM
Points: 183, Visits: 480
Answered super fast at the good ol - stackoverflow.com

http://stackoverflow.com/questions/19671214/bulk-insert-task-fails-but-actually-succeeds
Post #1509617
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse