MCQOPTIONS
Saved Bookmarks
| 1. |
You work as a database administrator at Abc.com. Abc.com network contains a development database server named ABC-DB06 and a production database server named TESCKLING-DB01. You are creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You include ABC-DB06 in the SSIS package. You publish the package to ABCDB06 but discover that you are not able to move the data between ABC-DB06 and ABC-DB01. You receive the following error message:The package could not link to ABC-DB06.You need to modify the package to reference the ABC-DB06 when it is implemented. What should you do? |
| A. | You need to change the features of the package in order to use the DontSaveSensitive package protection level. |
| B. | You need to change the features of the package in order to use the store procedure. |
| C. | You need to select the Connection Manager check box on the Connection Managers tab of the Execute Package utility and then change the connection string. |
| D. | You need to add to the expression on the Flat File Connection manager prior to modifying the connection string. |
| Answer» D. You need to add to the expression on the Flat File Connection manager prior to modifying the connection string. | |