i am not able to program the row delimiter in the columns tab of the flat file connection manager. what shall i do please could somebody help me on this i have programme the ssis connection manager for flat files but i am unable to reach the row delimiter dropdown box programatically.please help me
View 1 RepliesIn an Integration Services scrip ttask, I am trying to get the value from a DTSProperty of a Connection Manager object.
The code seems like it would be very straight-forward. Here is what I have...
Dim oCM As ConnectionManager
Dim oProp As DtsProperty
Dim sValue As String
oCM = Dts.Connections("SomeConnectionManager")
oProp = oCM.Properties("ServerName")
If oProp.Get Then
sValue = oProp.GetValue()
End If
The line inside the If block is the problem. Once you have a DTSProperty object, you should be able to get to the value of that property. GetValue is a method that either I can't figure out how to use correctly or it is broken. Looking at the MSDN documentation (msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtsproperty.getvalue.aspx), it says I have to provide an object parameter of the object I'm trying to get the value from. But the object I'm trying to get the value from is the object on which I'm executing this method. Gah! I've tried this sValue = oProp.GetValue(oProp) - but it doesn't work.
Am I doing something wrong? Is the object model broken?