I must be tired, because when I run a package I have been working on, I am now getting an IndexOutOfRangeException, and I cannot see where in this code it would come from. Can someone please help me open my eyes here? :) Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) Row.hotrates = GetBoolean(Row.hotrates, Row.hotrates_IsNull) Row.map = GetBoolean(Row.map, Row.map_IsNull) Row.overview = GetBoolean(Row.overview, Row.overview_IsNull) Row.reviews = GetBoolean(Row.reviews, Row.reviews_IsNull) Row.video = GetBoolean(Row.video, Row.video_IsNull) If Not Row.starrating_IsNull Then Try Row.starrating = Integer.Parse(Row.starrating, Globalization.NumberStyles.Integer).ToString Catch Row.starrating = "-1" End Try Else Row.starrating = "-1" End If End Sub Public Function GetBoolean(ByVal strObject As String, ByVal IsObjectNull As Boolean) As String If Not IsObjectNull Then Return String.Equals(strObject, "Y").ToString Else Return "False" End If End Function
This was working before. The moment I moved this (and a few other related items) into its own Data Flow Task, this error popped up.- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/