• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 122
  • Last Modified:

sql replication (SSIS)

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
IT-VAS
Asked:
IT-VAS
1 Solution
 
AnujCommented:
You need to make some changes to DefaultBufferMaxSize and DefaultBufferMaxRows, Check #7 of this article.
0
 
Alpesh PatelAssistant ConsultantCommented:
Please increase the buffer size
Untitled.png
0
 
IT-VASAuthor Commented:
hi PatelAlpesh,

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


thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now