I am having problems using the datapumptask for the DTS COM. I am trying to dump the data from SQL to Access. I used a select query from access. However I am not getting connected .

In the .destinationCommandProperties I recieve the following error when I am running the code. (using the watch)

"Multiple-step OLE DB operation generated errors. Check each OLE db status value"

I created the two connections and I have 1 step. and 1 task.