Post reply

Data for source column 4('IMDSC1) is too large for the specified buffer size

  • September 11, 2008 at 11:46 am

    #190752

    I am running a simple Data Flow process where I am basically taking data from the AS400 and dumping it over to a SQL2K5 table. There is one record with a value of [3.5" Disk Drive Kit] as a value and this one is not coming over correctly. Actually, the process fails when it reaches this record. I was able to do this via DTS just fine in SQL2K, but I have not figured out how to bring this over on my table. Do I have to convert the value and strip the double quotes for 2005? Thanks!

  • September 11, 2008 at 5:31 pm

    #870706

    Well, I guess I'll answer my own question on this one...

    The value in the AS400 was actually incorrect. SQL2000 seemed to be more "forgiving" and allowing this to come in as a value, but SQL2K5 seems to be a little more tight on data structure. Now, that still does not explain a whole bunch but at least it is now working. I do have to mention that the migration of objects and data to 2K5 is not as easy as I thought it was going to be.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply