I have a job which calls a SSIS package that runs early in the morning. Most of the times it fails but just rerunning the job fix the issue. The SSIS packages has 5 dataflows. Each dataflow populates around 14 tables simeltanously. I did doubled the buffer size for the dataflow but it did not help. The error for the job:
1)input column "CreatedDate" (1306) on input "Destination Input" The column status returned was: "Conversion failed because the data value overflowed the specified type.". Description: "Invalid character value for cast specification.".
2)Description: The attempt to add a row to the Data Flow task buffer failed with error code
3)Description: Setting the end of rowset for the buffer failed
Any help will be great.