0xC0209029 = DTS_E_INDUCEDTRANSFORMFAILUREONERROR means

The "__" failed because error code 0x__ occurred, and the error row disposition on "__" specifies failure on error. An error occurred on the specified...

Hi,

Well, this things help in reducing time effectively,

Now the main point is, Loop was given there just to give an idea that, that SQL query will run approx for...

HI,

I have used namespace System:: Data:: SqlClient for making and executing the queries.

SqlClient:: SqlDataReader for reading the result of the queries.

The first query is simple:

 ...