Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Bulk load data conversion error (truncation) for row 1


Bulk load data conversion error (truncation) for row 1

Author
Message
PNS
PNS
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 254
Hi,

I am getting the following error while doing a BULK Insert.
column 1 (a).,Bulk load data conversion error (truncation) for row 1, column 1 (a).,Bulk load data conversion error (truncation) for row 1, column 1 (a).,Bulk load data conversion error (truncation) for row 5, column 1 (a).,Bulk load data conversion error (truncation) for row 1, column 1 (a).,Bulk load data conversion error (truncation) for row 2, column 1 (a).,Bulk load data conversion error (truncation) for row 6, column 1 (a).,Bulk load data conversion error (truncation) for row 2, column 1 (a).,Bulk load data conversion error (truncation) for row 5, column 1 (a).,Bulk load data conversion error (truncation) for row 3, column 1 (a).,Bulk load data conversion error (truncation) for row 2, column 1 (a).,Bulk load data conversion error (truncation) for row 7, column 1 (a).,Bulk load data conversion error (truncation) for row 6,

This bulk insert is done through a SP and is called by EXCEUTE SQL TASK in a SSIS package. Another point is that this error does not come on all the machines; though we have same SQL server edition and service pack on these machines.

Any help/clue would be appreciated.

Thanks
PS
John H Marsh
John H Marsh
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1481 Visits: 1455
Hello,

Sorry for asking, but just to be sure, is the data in the first ”column” of the import file too wide to fit in the target table’s column?

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group
PNS
PNS
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 254
John,

I checked the length of the field and column. They are in sync.Also when I re ran my package, it executed without any problem. I am looking for the reason why it happened. Will post it if I get any clue.

Thanks
Parul
etm1109
etm1109
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 154
I'm guessing that today, you got some data in your upload file/source that is missing. I'd first start checking date fields for missing, null or incorrect syntax.

Then move onto the numeric fields.

I know one of the things I always did writing DTS/SSIS was put in checks on my date fields that if they were null, I defaulted to something like '1/1/1970.'
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search