What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is connected to a database on your development server by using a connection manager. You decide to use the DTExecUI utility to run the package. You need to change the connection of the connection manager to a different server at run time without using a package configuration file. What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is connected to a database on your development server by using a connection manager. You decide to use the DTExecUI utility to run the package. You need to change the connection of the connection manager to a different server at run time without using a package configuration file. What should you do?

A.
Specify an appropriate command file by using the Command Files dialog box.

B.
Specify an appropriate Connection String variable in the Set Values dialog box.

C.
Specify an appropriate package configuration by using the Configurations dialog box.

D.
Specify a different connection string for the connection manager by using the Connection Manager dialog box.



Leave a Reply 0

Your email address will not be published. Required fields are marked *