You have a SQL Server Integration Services (SSIS) package named Package1. You discover that the Data Flow task for Packa

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

You have a SQL Server Integration Services (SSIS) package named Package1. You discover that the Data Flow task for Packa

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply