传递给LEFT或SUBSTRING函数的长度参数无效 [英] Invalid length parameter passed to the LEFT or SUBSTRING function

问题描述

我有一个OLEDB源查询，它使用子字符串函数来获取值。在SSMS中使用相同的数据运行查询时，我没有收到任何错误，并且它正在给出成功的结果，但是在SSIS服务器中通过SSIS包执行相同的查询时调度
。我收到以下错误。

"传递给LEFT或SUBSTRING函数的长度参数无效"。

I have a OLEDB source query that uses substring function to fetch the value. while running the query with the same data in SSMS i am not getting any errors and it is giving the successful results but while executing the same query through SSIS packages scheduled in SSIS server . I am getting the below error.
"Invalid length parameter passed to the LEFT or SUBSTRING function".

当我通过BIDS为相同的数据运行程序包时，我没有收到错误，但是只有在运行ssis服务器中的预定作业时才会出现。

when i am running the package through BIDS for the same data i am not getting the error but ots only coming when running through the scheduled job in ssis server.

套件在过去3年中成功运行但突然出现此错误。我不知道发生了什么。

Package was running successfully from the past 3 years but suddenly this error is popping out . I have no clue what is happening .

我手动验证了数据，但没有任何线索，因为所有数据都是正确的。

I have validated the data manually as well but no clue as all the data is correct.

请帮助建议出现此错误的原因或我如何调试此错误。

Please help in suggesting what can be the reason of this error or how i can debug this error.

推荐答案

您好，

无需在此论坛中发布相同的问题两次。 />


请删除这篇文章。

There is no need to post the same question in this forum twice.

Please just delete this post.

最好的问候，

Mona Lv

这篇关于传递给LEFT或SUBSTRING函数的长度参数无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！