You have a SQL Server Integration Services (SSIS) package named Package1. You discover that the Data Flow task for Package1 runs slower than expected. You need to reduce the amount of time required to run the Data Flow task. Which two actions should you perform? Each correct answer presents part of the solution.

A. Modify the DefaultBufferMaxRows package setting.
B. Configure the package to run by using the CallerInfooption.
C. Modify the ForceExecutionResult package setting.
D. Configure the package to run by using the MaxConcurrent option.
E. Modify the DefaultBufferSize package setting.

  Discussion forum

Question
0

Leave an answer