question:
Error Desc: Failed to retrieve long data for column”TS_Description”.
When
, 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.
solution:
reset data source and data destination, save.
Read More:
- ERROR 1406 (22001): Data Too Long, field len 30, data len 48
- SSIS Error:Package Validation Error. SSIS Error Code DTS_E_OLEDBERROR. .Error code: 0x80040E37. An …
- circuit_breaking_exception,“reason“:“[parent] Data too large, data for [＜http_request＞]
- 【Error】gRPC failure=Status{code=UNAVAILABLE, description=io exception, cause=io.netty.channel.
- Word column after the text evenly distributed in the left and right two columns, rather than fill in the left column and then fill in the right column, how to do?
- TS Failed to Use hasOwnProperty Method [How to Fix]
- Failed to retrieve platformtransactionmanager for @ transactional test: [defaulttest]
- Renaming the column name of data frame in R language
- SSIS package error report login failed for user’nt authority\anonymous logon’ solution
- Description: Failed to decrypt protected XML node “DTS:Password” with error 0x8009000B “Key not valid for use in specified state
- The Excel connection manager is not supported in the 64-bit version of SSIS [Switch]
- Ubuntu reads the shared folder under windows Unable to mount location Failed to retrieve share list from server
- Failed to load response data:No data found for resource with given identifie
- In the SQL query statement, add the column that does not exist in the table and set the fixed value of the column
- Error reading JSON file: json.decoder.JSONDecodeError : Extra data: line 6 column 2 (char 1329)
- pandas parse_ Data exception, automatically skip
- “[warning] failed to retrieve plugin descriptor for caused by Maven security agent settings org.apache.maven . plugins:… “
- SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED
- Failed to retrieve plugin descriptor for org.mybatis.generator :mybatis-generator
- error TS2339:Property ‘length’ does not exist on type ‘object’