?
Solved

sql replication (SSIS)

Posted on 2011-09-15
5
Medium Priority
?
117 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 2000 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

771 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