70-448 · Question #177
You are developing a SQL Server 2008 Integration Services (SSIS) package for Company.com. There is a development server called TestSQL in your package. For the development server and the production…
The correct answer is C. You should choose the Connection Manager check box on the Connection Managers tab of the Execute. Creating Package Connection Managers A package connection manager, sometimes simply called a package connection, is independent of project data sources. However, package connections can reference a project data source. A package connection lets the different components in SSIS…
Question
You are developing a SQL Server 2008 Integration Services (SSIS) package for Company.com. There is a development server called TestSQL in your package. For the development server and the production server, you could not move the information between them. When you publish the package to the TestSQL server. You get the error message below:The package could not link to the TestSQL server. You should make sure that you could alter the package to refer to the TestSQL server when being implemented. Which is the correct answer?
Options
- AYou should change the attributes of the package to utilize the DontSaveSensitive package protection level.
- BBefore altering the connection string by hand you should change the deployment manifest file in
- CYou should choose the Connection Manager check box on the Connection Managers tab of the Execute
- DYou change the attribute of the package to utilize store procedure.
How the community answered
(55 responses)- A9% (5)
- B15% (8)
- C73% (40)
- D4% (2)
Explanation
Creating Package Connection Managers A package connection manager, sometimes simply called a package connection, is independent of project data sources. However, package connections can reference a project data source. A package connection lets the different components in SSIS communicate with an object (such as a database, file, or server) outside the package. You can use package connections as source adapters, FTP or e-mail servers, or flat files.
Topics
Community Discussion
No community discussion yet for this question.