February 22, 2011 at 11:16 pm
I have an SSIS package deployed on the server. After deployment, for few days it works fine but after few days is stops working and once again we need to build the package on server and deploy it there.
Actual problem is that when I deploy the SSIS Package it works fine but after couple of days it stops functioning as desired and generates the error.
Please help to get the reason behind this.
February 22, 2011 at 11:32 pm
Please post error message...
February 22, 2011 at 11:38 pm
Error: 0xC020209C at Upload EP Data, DAT File Reader [1]: The column data for column "SYSTEM_LOCKED" overflowed the disk I/O buffer.
February 23, 2011 at 1:24 pm
Chances are you're trying to read a Unicode file as ANSI or the end of line character in your file connection in SSIS (e.g. {CR}{LF} ) is different from the data file.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply