Hi, On execution of Execute SQL Taskwithout parameter does not have error.. when i set the parameter User:ItemId - and pass the sql statement SELECT [COLUMN] FROM [DBO].[TABLE] WHERE COLUMN_ID = ? , i get error [Execute SQL Task] Error: Executing the query "SELECT [COLUMN] FROM [DBO].[TABLE] WHERE COL..." failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. What would be the problem.. where should i check for the fix ? ShanmugaRaj

Have you set "Parameter Name" property on the variable as 0. Check this which gives an illustrated example on how to pass variables to and from Execute SQL task.http://btsbee.wordpress.com/

Please make sure to set "Parameter Name" property as 0 and the variable name should be User:ItemId ( as you mentioned above ) under parameter mapping in Execute SQL Task. Also verify the Result Set Property in the Execute SQL as either a Single Row or a full resultset(depends how many rows returns when the query executes).