CODEWITHSUNDEEP
ssis
Kumar Ranjan
Kumar Ranjan

Reputation: 1

SSIS ADO.DET Performance Issue

If I have 20 GB flat file source and want to load it to the SQL server destination using ADO.NET destination and in the process of doing so the performance is very slow.

Please Suggest Thanks

Upvotes: 0

Views: 698

Answers (1)

Kobi
Kobi

Reputation: 2524

If you use ADO.net with at least SQL Server 2008 R2, you have to check the dataflox option : Use bulk insert when possible

", then you can change dataflow properties like DefaultBufferMaxRow and DefaultBufferSizeand BatchSize
Adjusts the value to find the best performances.

On other hand you can try to drop /recreate indexes/PK before and after loadding data.

What about OLE DB destination? if you are able to use it, it can be a better solution

Upvotes: 1

Related Questions