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

Using DTS how can I set the batch size?

How can I set the batch size to a small number of records (1000 for example) using DTS? I cannot find the option.
0
robrodp
Asked:
robrodp
1 Solution
 
Anthony PerkinsCommented:
Use the option "Use a query to specify the data to transfer" and use a TOP clause in your query, as in:

SELECT TOP 1000 *
FROM TABLE1
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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