I have an SSIS package execute SQL task that updates a foxpro table where it has more than 2 million records. The update is done after importing foxpro data to a sql database. The update task indicates as running (yellow color) continuously but
nothing is updated. The same update command if given within foxpro, it works and update is completed within few seconds. If I try to update only a subset (for example only about 2000 records in the concerned table) from SSIS then it works as well. This indicates
I presume that the failure is as a result of a waiting cause by higher number of records. Is there any way make this work? What are the alternative work arounds? Any help is greatly appreciated.
View Complete Post