Hi
I've been working on a ETL task, using BODI as my ETL tool and my source and target comprises of sql server 2005. I found this error occuring frequently when ever I try to update my target with the source . The number of records that have to be compared are 2.5 crores of the target with that of 1.8 crores of source , for this I have used all the methods to optimize the load on the server, but still I face the same. Only option is to truncate the target and load it , which is just against the rules of ETL.
This error has occured even after removing all inmemory caches in the ETL tool and tried executing it
the complete error is
dataflow df_lkp_update|reader customer_mis_102008
ODBC data source :<[microsoft][ODBC sql server Driver][DBNETLIB]ConnectionRead (recv( ))
Can someone help me out to fix this bug.
Thanks
VJ