Solved

sql replication (SSIS)

Posted on 2011-09-15
5
113 Views
Last Modified: 2014-01-06
hi,

i need to replicate the amount of the data from one sql server database to another sql database, the table that must be replicated contains 152511786 rows and when i run my packge in SSIS i get the flowing informations:

  result.txt
0
Comment
Question by:IT-VAS
5 Comments
 
LVL 15

Expert Comment

by:Anuj
ID: 36541295
You need to make some changes to DefaultBufferMaxSize and DefaultBufferMaxRows, Check #7 of this article.
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 500 total points
ID: 36542396
Please increase the buffer size
Untitled.png
0
 

Author Comment

by:IT-VAS
ID: 36547828
hi PatelAlpesh,

How much can you  increase this value? wht is the range?


thanks
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s a strangely common occurrence that when you send someone their login details for a system, they can’t get in. This article will help you understand why it happens, and what you can do about it.
An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question