var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL Server DTS
I am using SQL Server Data Transformation Services to import data from a MS Access DB to a SQL Server DB.
One of the fields of the SQL Server table is of type varchar with size set to maximum of 8000.
However, when I import the data I get this error:
Error at source for number 932. Errors encountered so far in this task: 1.
Data for source column 4 ('Solution') is too large for the specified buffer size.
Solution is the name of the column in the SQL Server table.
I don't know what I can do to correct this as I have set the field to the maximum size!
Looks like you have bad data in record:Error at source for number 932 of the source table. Make it easy on yourself. drop it in exel.