CODEWITHSUNDEEP
sql-serverssisbulkinsertbatch-processing
Shumii
Shumii

Reputation: 4581

SSIS Batch Processing

Can anyone please tell me how to perform a simple batch process in SSIS?

I know how to do such a thing using T-SQL and/or .NET code but what I wish to do is to use the SSIS GUI to do this entirely. I am not sure if it is possible and all I can find on Google are over complicated solutions.

To explain a bit more - I am reading from a flat file and I want to insert its entire contents into a Sql Server table. Pretty simple huh... But I want to do it 50,000 records at a time. I expect this to be as simple as setting a property somewhere or at the most using some kind of loop tool from the toolbox.

Thanks

Upvotes: 1

Views: 3972

Answers (1)

Alberto De Caro
Alberto De Caro

Reputation: 5213

You are right. It is a property of the Data Flow task.

Right click on the task, click on the "Properties..." command, look for the DefaultBufferMaxRows property and set the desired value.

References @MSDN.

enter image description here

Upvotes: 3

Related Questions