Issue With The Use Of OLEDB Command Task To Update Db2 Target Table

I am having a problem on updating data in DB2 target table.

I followed BJ Custard's (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1058272&SiteID=1&mode=1)(thanks amillion!) post and configured OLEDB destination to insert data. But I have to also update or delete data from the target table based on flag from source.

I tried using OLEDB command which uses the OLEDB connection created by following the steps posted in above link.

Trail 1real requirement):
When I used the SQL query:


delete from table where Col1=? and Col2=?

I am unable to map to the parameters. When I click refresh button after writing the query, I get "There is a data source column with no name. Each data source column must have a name." message. Added to before message, there are no parameters to map to.


Trail 2:
When I hard code the parameters :

delete from table1 where Col1='abc' and Col2='xyz'

no parameters will come up, so no mapping. So when I execute the mapping I get the following error:



Error: 0xC0202009 at Load .....................................................: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E00.
Lookup on above error codes show those are related more to target Db2 database.

I am sure some one might have used the OLEDB command task, not only just insert task.

Any help is really appreciated.