get the app

Question: You work as a database administrator at 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 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?

1)You need to change the features of the package in order to use the DontSaveSensitive package protection level.
2)You need to change the features of the package in order to use the store procedure.
3)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.
4)You need to add to the expression on the Flat File Connection manager prior to modifying the connection string.

Previous Next

Suggest other answer
Login to Discuss/suggest the answer...

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence

Recommended Learning for you

Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material