You are a database administrator for AIOTestKing.com. You are creating a new SQL Server Integration Services (SSIS) package. The package will import one or more text files into a database each night. These text files are provided by company vendors and are not related to one another. You need to ensure that the package always succeeds, even if no text files are provided, with the least amount of administrative effort. What should you do?
A.
In the SSIS package, use a Merge Join transformation to combine the data from the files.
B.
Configure the SSIS package precedence constraints to be dynamically allocated.
C.
Configure the SSIS package to use transactions.
D.
In the SSIS package, use a For Loop condition to iterate through the available files.
Explanation:
Use the For Loop page of the For Loop Editor dialog box to configure a loop that repeats a workflow until a specified condition evaluates to false.