Problems With OLE DB Command Transformer

I am trying to use the OLE DB Command Transformation to update rows in my table. When I make the connections and select the connectionmanager I get the following error:

Error at Data Flow Task [OLE DB Command [6624]]: An OLE DB error has occurred. Error code: 0x80040E0C.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E0C Description: "Command text was not set for the command object.".

I cannot figure out what to do. The connection is valid. I have used it in many places in the data stream. I also see that there are no output columns available for mapping. I didn't see a place to select the table.

Can anyone please help.

Thanks,

Lee

Make sure you are setting the SQLCommand property (on the Component Properties tab) with your UPDATE statement.|||Thanks. One more question - Do you have to use ? (i.e. scope = ?) for the parameters in the SQL statement or can you use something that is more meaningful?|||With most OLE DB drivers, you do need to use ?. That is the way the drivers expect to see parameter placeholders.