What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is named UpdateTable.dtsx and contains a variable named runID. The package must run by using the dtexec utility. The runID variable must be set at runtime to a value of 5. You need to meet the outlined requirements. What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is named UpdateTable.dtsx and contains a variable named runID. The package must run by using the dtexec utility. The runID variable must be set at runtime to a value of 5. You need to meet the outlined requirements. What should you do?

A.
Execute dtexec /F “c:\ssisPackages\UpdateTable.dtsx” /SET \packages.variables[runID].Value;5.

B.
Execute dtexec /F “c:\ssisPackages\UpdateTable.dtsx” /SET \packages.variables.runID=5.

C.
Create a text file that specifies the variable name and value in the format package.variables[runID].Value =
5. Execute dtexec /F “c:\ssisPackages\UpdateTable.dtsx” /COM <filename> where <filename> is the name of the file you just created.

D.
Create a text file that specifies the variable name and value in the format runID=5. Execute dtexec /F “c:\ssisPackages\UpdateTable.dtsx” /COM <filename> where <filename> is the name of the text file you just created.



Leave a Reply 0

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