Check for timeout in the bulk insert, I would guess. *Hibernating Rhinos Ltd *
Oren Eini* l CEO l *Mobile: + 972-52-548-6969 Office: +972-4-622-7811 *l *Fax: +972-153-4-622-7811 On Wed, May 3, 2017 at 1:45 PM, Vijay Sheganti <[email protected]> wrote: > Yes. > I am reading data from the source and target using InputCommandOperation > (2 diff classes) and joining to check for existence in the target table. If > the records do not exist in the target, inserting them using > SQLBulkInsertOperation. > As I am not seeing any records in target table for all the source data, I > have modified my query which pulls data from source to pull a specific > number of records.During this experiment, I found it's inserting 60K > records and not more than that. > > Verified space in DB and my code. Not sure what else should I do. Thankful > for any help on this. > > On Wednesday, May 3, 2017 at 1:57:53 PM UTC+5:30, Ayende Rahien wrote: >> >> Are you doing that as a single transaction? >> >> *Hibernating Rhinos Ltd * >> >> Oren Eini* l CEO l *Mobile: + 972-52-548-6969 <052-548-6969> >> >> Office: +972-4-622-7811 <04-622-7811> *l *Fax: +972-153-4-622-7811 >> <153%204%20622%207811> >> >> >> >> On Wed, May 3, 2017 at 11:26 AM, Vijay Sheganti <[email protected]> >> wrote: >> >>> I have a package which reads data from the source and insert to target >>> table based on the record existence. Everything works fine when the source >>> record count is up to 60000. Will there be any settings or reasons for such >>> behaviour? BTW, the source contains 700K records. I wanted to load all in >>> a single run. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Rhino Tools Dev" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at https://groups.google.com/group/rhino-tools-dev. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to the Google Groups > "Rhino Tools Dev" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/rhino-tools-dev. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/rhino-tools-dev. For more options, visit https://groups.google.com/d/optout.
