Use FastLoad at Destination ,try to use the batch size depending upon the buffer size .If you use Fast load and Buffer size of 0 it will push all the rows in single transaction,it may create some back pressure on the flow .
Avoid using sqlserver destination if your destination is on different server.
Make sure to turn on trace flag 610 for minimal logging.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.