Tuesday, March 27, 2012

Getting the data type of the IDTSCustomProperty90 object

Hello,
I want to get the datatype of the IDTSCustomProperty90 object which I get from my IDTSComponentMetaData90.CustomPropertyCollection.

I tried IDTSCustomProperty90 .ObjectType.GetTypeCode() and I get Int32 for all properties. How do I get the data type for each property in the custom property collection. In case of a control flow executable I simply get it by calling DtsProperty.Type (the Type property).

Hence I guess there has to be something which will give me the data type of the custom property as well.

Thanks
-Suri
The Integration Services development team has already responded to your question in the thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=149182&SiteID=1 on the same subject that you started a few days ago.

Data flow custom properties do not have a fixed data type until a value is assigned to them, after which point the data type cannot be changed from the data type of the initial assigned value.

-Doug

No comments:

Post a Comment