You are a database administrator for AIOTestKing.com. You have many complex SQL Server Integration Services (SSIS) packages that move data among your servers. The SSIS packages import and export data to and from your company’s trading partners. The SSIS packages can only run after certain conditions are met that exist outside of SQL Server. Your department uses a third-party tool to schedule the running of nightly scripts to test for these conditions. You need to run SSIS from your scripts as seamlessly as possible. What should you do?
A.
When conditions are met in the scripts, have the scripts execute the DTExec utility to run the SQL Server Integration Services (SSIS) packages.
B.
When conditions are met in the scripts, have the scripts execute the DTUtil utility to run the SQL Server Integration Services (SSIS) packages.
C.
Have the scripts write a status code to a text file that the SQL Server Integration Services (SSIS) packages look for and act upon.
D.
Create a trigger that runs the SQL Server Integration Services (SSIS) packages.