Solved

sql replication (SSIS)

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
encrypt SQL Server 2008 port 1433 3 40
store vs query adhoc - no show rows 4 30
What is GIS method of Geometry data type? 6 26
VM SQL server license. 1 50
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
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.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…

742 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