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.
Back up the master database and restore it to the production server. Rename the appropriate tables inside the master database.
C.
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.
D.
Back up the msdb database and restore it to the production server. Rename the appropriate tables inside the msdb database.
Explanation:
You have to use a SSIS package to accomplish this but you can not use the package built for your development environment as the table names differ.