You are running a training exercise for Microsoft SQL Server 2012 junior developers. Which of the following represents the data type for this property?

The correct answer is A. Integer. The question is incomplete as presented (it references 'this property' without an exhibit), but based on the answer choices and context, the correct answer is Integer. In SSIS, properties such as Count (e.g., the count of external metadata columns in a collection) are of type…

Extract and transform data

Question

Options

AInteger
BIDTSExternalMetadataColumn100
CString
DBoolean

How the community answered

(24 responses)

A
92% (22)
C
4% (1)
D
4% (1)

Explanation

The question is incomplete as presented (it references 'this property' without an exhibit), but based on the answer choices and context, the correct answer is Integer. In SSIS, properties such as Count (e.g., the count of external metadata columns in a collection) are of type Integer. IDTSExternalMetadataColumn100 is an SSIS interface type representing a metadata column object, not a primitive data type. String and Boolean are incorrect for numeric/count-style properties. The Integer type is used for properties that return a numeric count or index within SSIS metadata collections.

Topics

#SSIS metadata#IDTSExternalMetadataColumn100#data types#SQL Server 2012

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice