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.


Discussion

No Comment Found