Solved

sql replication (SSIS)

Posted on 2011-09-15
5
111 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.

747 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now