YOU RECEIVE A DATA FILE EACH DAY FROM A BUSINESS PARTNER. YOU NEED...

16. You receive a data file each day from a business partner. You need to import

the file each morning after it is received. Your developers have created a

package to properly import the file, and have deployed the package to your

SSIS instance. When they saved the package, they used the “Encrypt all with

Password” protection level. You need to make sure the password can’t be seen

in the scheduled job’s definition. What should you do to schedule the package?

A. Create a SQL Server Agent job and use an “Operating System (cmdExec)”

step to run the DTExec utility

B. Create a SQL Server Agent job and use a “SQL Server Integration Services

Package” step

C. Use the “Scheduled Tasks” in windows to run the DTExec utility nightly

D. Use the “Scheduled Tasks” in windows to run the DTExecUI utility

nightly