first of all the out of my curiosity because if option is there then I should be able to use it.

second I need to append data in same table so...

I am getting column a,b,c from access database in oledb source and now I want to insert this data into oledb destination using sql command mode.

I have a table create...

Hi Hans,

thanks for update.

its not working in my database .it is not returning anything after giving the sp name.

Regards

Amit