SSIS Exception: Failed to retrieve long data for column “TS_Description”


Error Desc: Failed to retrieve long data for column”TS_Description”.


, go to the package and check in which step you use “TS_Description”.

finds that the step used is a data flow. There’s a yellow warning on it. I can’t remember the specific warning message. (The next time you encounter it, fill in the warning.)

recalls that the table that has not touched destination, as source is a table of other systems, I am not sure whether it has been changed.

then reset the data source and data destination in the data flow, click ok and save. Just run it.

could be that the property of this column in source or destination, such as length, has changed.


reset data source and data destination, save.

Read More: