Became a Gold Member and access 40+ Technology Courses...
Live Help (Start Chat)
Interview Questions and Answer
Options:
a. By referencing the parent package's variables from the child packages using a package configuration
b. Add the variables to be used by the child packages to the parent package's Shared Variable collection
c. This functionality is not supported by SSIS
d. Establish an inter-program named pipe between the packages at runtime
Reveal Answer
Options:
a. Right click on the value and click the \view line age\ menu option
b. By reviewing the package progress window
c. By turning on detailed package logging and reviewing the lot after the next test run
d. SSIS does not provide this functionality
Reveal Answer
Options:
a. pre-execution or post-execution
b. loop iteration
c. on warning
d. on error event of a single task container or package
e. All the Above
Reveal Answer
Options:
a. Executing the package partially
b. Debugging Control Flow tasks
c. Debugging Data Flow task
d. All the Above
Reveal Answer
Options:
a. Recode the package based on the functionality in SQL Server DTS
b. Use the Migrate DTS 2000 Package wizard in BIDS then recode any portion of the package that is not accurate
c. None the Above
Reveal Answer
Options:
a. Setting up breakpoints
b. Using Progress tab information
c. Using Debug windows
d. None of the above
Reveal Answer
Bestdotnet google plus