I got error while ruing my ETL package,
[Execute SQL Task] Error: Executing the query "EXEC KFSor_XFormFsrReward @Auditkey" failed with the following error: "KFSor_XFormFsrReward: Conversion failed when converting the varchar value '2012-03-03' to data type int.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
can any one Please help me.....
ETL = Extract Transform Load ? If yes, it seems that you are the SQL Server Integration Services especially because i have seen in the error message [Execute SQL Task]. If it is true, a moderator can move your thread towards the related forum.For myself, i do the move only after having the agreement of the original poster ( Sandip_ ).
In your error message, i have seen "Conversion failed when converting the varchar value '2012-03-03' to data type int.". It seems for me that 2012-03-03 could be a date with the format YYYY-MM-DD or YYYY-DDD-MM ( 3rd March of 2012 ) and i don't think that the datetime can be converted to an data type int ( conversion unauthorized for SQL Server.
Among the 4 possible reasons of the failed query , 2 reasons seem possible : problems with the query or parameters not set correctly.
I would suggest to have a look at your package ( look at the value of the parameter Auditkey and see if its data type would be int and its provided value is 2012-03-03 , if i am right, your problem could comr from here )
Please, could you explain how is created and used the KFormsFsrEward and which is the version (2000,2005,2008,2008 R2,2012) and the edition (Workgroup,Standard,Entreprise,...) of your SQL Server ?
We are waiting for your feedback ( and possible agreement for the move ) to try to help you more efficiently.
Have a nice day
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.