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.
