I have been trying to truncate a number of tables in 1 DWH. after setting my object parameter ,going into the loop my sql statement is : truncate table ? after executing the following error :
[Execute SQL Task] Error: Executing the query "truncate table ?" failed with the following error: "An error occurred while extracting the result into a variable of type (DBTYPE_I4)". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.