January 18, 2007 at 9:02 am
I am getting data from table to Excel using DTS...and I am getting this for some of the table, when I run very first I didnot got this error but after running again I am getting this for 2 of the tables and rest is working fine.
MS-SQL DTS Data for source Column 48 (notes) is too large for the specified buffer size
Thanks in advance
Nita
January 18, 2007 at 9:58 am
Save the file as CSV or txt and try importing. You can also refer to http://support.microsoft.com/kb/281517/EN-US/
Prasad Bhogadi
www.inforaise.com
January 18, 2007 at 10:24 am
It was 8 I made it 16, I did re boot my PC but stills its not working.
Nita
January 18, 2007 at 11:16 am
Can u check with the .txt or .csv extensions? Or please open your excel file and paste some data that has more than 256 characters in the first row and test it.
Prasad Bhogadi
www.inforaise.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply