SSIS job has failed and posting the below error
SSIS作业失败并发布以下错误
[Product Sales [749]] Error: An exception has occurred during data insertion, the message returned from the provider is: The given value of type String from the data source cannot be converted to type float of the specified target column.
[Product Sales [749]]错误：数据插入期间发生异常，从提供程序返回的消息是：数据源中String类型的给定值无法转换为指定目标列的float类型。
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Product Sales" (749) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (752). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
[SSIS.Pipeline]错误：SSIS错误代码DTS_E_PROCESSINPUTFAILED。组件“产品销售”（749）上的ProcessInput方法在处理输入“ADO NET目标输入”（752）时失败，错误代码为0xC020844B。标识的组件从ProcessInput方法返回错误。该错误特定于组件，但错误是致命的，将导致数据流任务停止运行。在此之前可能会发布错误消息，其中包含有关失败的更多信息。
Can some one please advise if you have come across this kind of error
有人可以告诉你是否遇到过这种错误
Thank you
谢谢
1 个解决方案
#1
1
Your error message is explaining the issue to you: "The given value of type String from the data source cannot be converted to type float of the specified target column."
您的错误消息向您解释了问题：“数据源中String类型的给定值无法转换为指定目标列的float类型。”
Open the component that is failing and review the metadata. You have a float column somewhere and you are passing this column a string that can't be converted to a float, such as empty space or an alphanumeric value.
打开失败的组件并查看元数据。您在某处有一个浮点列，并且您将此列传递给无法转换为浮点数的字符串，例如空格或字母数字值。
If you want to ensure these values are floats, you can add a script component above the one that is failing and write some code to ensure the value is properly sanitized:
如果要确保这些值是浮点数，可以在失败的值上方添加脚本组件，并编写一些代码以确保正确清理该值：
string input = "1.1"; //Replace with your input buffer value
float result;
float.TryParse(input, out result); //Result = 0.0 if value was not parsed
#1
1
Your error message is explaining the issue to you: "The given value of type String from the data source cannot be converted to type float of the specified target column."
您的错误消息向您解释了问题：“数据源中String类型的给定值无法转换为指定目标列的float类型。”
Open the component that is failing and review the metadata. You have a float column somewhere and you are passing this column a string that can't be converted to a float, such as empty space or an alphanumeric value.
打开失败的组件并查看元数据。您在某处有一个浮点列，并且您将此列传递给无法转换为浮点数的字符串，例如空格或字母数字值。
If you want to ensure these values are floats, you can add a script component above the one that is failing and write some code to ensure the value is properly sanitized:
如果要确保这些值是浮点数，可以在失败的值上方添加脚本组件，并编写一些代码以确保正确清理该值：
string input = "1.1"; //Replace with your input buffer value
float result;
float.TryParse(input, out result); //Result = 0.0 if value was not parsed