You are the administrator of your company network. You are in charge of a SQL Server 2008 instance. The SQL Server Import and Export Wizard creates SQL Server 2008 Integration Services (SSIS) packages. And now you intent to deploy the packages which will use stored user names and passwords to link to external data. You must prevent users who are not authorized to access the user names and passwords. So what should you do to ensure this?
A.
You should make sure that no data is saved along with the packages, and save the files to the most secure directory.
B.
You should store the packages by using the SQL Server 2008 server, manage the security in the SQL Server 2008 server.
C.
You should set a common password to make all data in the package as secure as possible when each package is saved.
D.
You should make sure that there is no sensitive data saved along with the packages, and save the packages in the SQL Server 2008 server.