InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 21 Nov 2009 20:49:15 GMT20http://www.sqlservercentral.com/Forums/Topic738043-8-1.aspxI'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.' Mon, 29 Jun 2009 07:56:49 GMTZETMhttp://www.sqlservercentral.com/Forums/Topic738043-8-1.aspxJohn,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.ThanksParulMon, 29 Jun 2009 02:04:43 GMTPNShttp://www.sqlservercentral.com/Forums/Topic738043-8-1.aspxHello,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 MarshFri, 19 Jun 2009 02:59:05 GMTJohn H Marsh http://www.sqlservercentral.com/Forums/Topic738043-8-1.aspxHi,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.ThanksPSThu, 18 Jun 2009 22:32:30 GMTPNS