October 20, 2011 at 4:46 am
Hi All,
I am trying to create a table that gives the info on the ETL flow status and to make a simpler version of it i have used a foreach loop, File system task and Execute sql task...
The foreach loop loops through the files in one folder, File system task then copies those files to a new destination...
Now i want to use the same variable used in foreach loop in execute sql task as a parameter and update the filestatus column from '0' to '1'.
So the file that is being copied, only its status is set to 1.
The problem here is execute sql task is failing....
Error: [Execute SQL Task] Error: Executing the query "update dwhflow
set FileStatus=1
where FName=Banking" failed with the following error: "Parameter name is unrecognized.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
But everything is perfect, the parameter, result set etc....
October 20, 2011 at 6:22 am
ambarishan.purushothaman (10/20/2011)
Error: [Execute SQL Task] Error: Executing the query "update dwhflowset FileStatus=1
where FName=Banking"
If you're sure that FName is the field, is it just a matter of missing single quotes around the string ('Banking')?
October 20, 2011 at 6:29 am
The Banking is the first file that is being copied and its passed as a parameter. I dont suppose it requires a ' '.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply