Microsoft Exam 70-463 Topic 7 Question 6 Discussion

Actual exam question for Microsoft's 70-463 exam

Question #: 6
Topic #: 7

You have a SQL Server Integration Services (SSIS) package. The package contains a script task that has the following comment.

// Update DataLoadBeginDate variable to the beginning of yesterday

The script has the following code.

Dts.variables[''User::DataLoadBeginDate''].Value = DataTime.Today.AddDays(-1);

The script task is configured as shown in the exhibit. (Click the Exhibit button.)

When you attempt to execute the package, the package fails and returns the following error message: ''Error: Exception has been thrown by the target of an invocation.''

You need to execute the package successfully.

What should you do?

AAdd the dataLoadBegin Date variable to the ReadOnlyVariables property.

BAdd the DataLoadBeginDate variable to the ReadWriteVariables property.

CModify the entry point of the script.

DChange the scope of the DataLoadBeginDate variable to Package.

Show Suggested Answer

Suggested Answer: B

You add existing variables to the ReadOnlyVariables and ReadWriteVariables lists in the Script Task Editor to make them available to the custom script. Within the script, you access variables of both types through the Variables property of the Dts object.

References:

https://docs.microsoft.com/en-us/sql/integration-services/extending-packages-scripting/task/using-variables-in-the-script-task?view=sql-server-2017

by Rima at May 07, 2022, 12:09 AM

Limited Time Offer

25%

Off

Get Premium 70-463 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!