You are a database administrator for AIOTestKing.com. You have separate SQL Server 2005 development and production environments. You use the Business Intelligence Development Studio to create a SQL Server Integration Services (SSIS) package in your development environment. Then, you use the SSIS package to import data into your development environment from one of your company’s trading partners. You need to deploy the SSIS package to your production environment. Your production environment uses different table names than your development environment. What should you do?
A.
Save the SQL Server Integration Services (SSIS) package to a file. Copy the file to the production server. Configure the SSIS package on the production server to use the new file.
B.
Create a SQL Server Integration Services (SSIS) package configuration. Build a deployment utility. Copy the deployment folder for your SSIS project to your production server. Execute the manifest file.
C.
Back up the master database and restore it to the production server. Rename the appropriate tables inside the master database.
D.
Back up the msdb database and restore it to the production server. Rename the appropriate tables inside the msdb database.
Explanation:
You want to create a new package configuration and a new deployment utility for the production environment as the tablenames do not match.