SurendraThotaMSBIProfessional

when we are trying to load huge data using ssis we are getting this error ole has sent a request and is waiting for a reply in ssis. The solution we got is apply delay validation = true on the package level so that you can avoid the above error.

Hi All    when are trying to load Float value into Varchar column the data is load with exponential notation .  which is not good for reporting , so we want represent the number as it is without  e   , so when try to convert that float into Bigint  and then convert into varchar we got the  error.  again tried with decimal(38,0)  still got the below error   Msg 8115, Level 16, State 6, Procedure mdm_GetEndXCustomerDetails, Line 16 Arithmetic overflow error converting float to data type numeric.   Then we have used the STR() function which worked very well   LTRIM ( Str ( mem . [MemberCardNo] , 38 , 0 ))  Hope this will save your time