Connector Rule - Object reference not set to an instance of an object

When I use that function, I get the following error:

Those are declared as constants

#Region "Constants and Enumerations"

		Dim connectionName As String = "OneStream BI Blend"		
		
		Dim columnNames As String() = {"Account", "AccountType", "Amount", "Credit", "Debit", "Department", "Entity", "Flow", "IC", "Location", "PLCategory", "SourceID", "UD1_ProfitCentre", "UD2_Category", "UD3_Projects", "UD4_DataAudit"}
		
		Dim columnNamesDrillBack As String() = {"Entity", "EntityDesc", "Period", "Account", "AccountDesc", "AccountType", "Debit", "Credit", "Amount", "Debit", "Credit", "Amount", "PLCategory", "Division", "Department", "DepartmentDesc", "Location", "LocationDesc", "PropertyLocation", "PropertyLocationDesc", "ProjectCode", "ProjectCodeDesc"}
		
		Dim accountTypePL As String() = {"COGS", "DeferExpense", "Expense", "Income", "OthExpense", "OthIncome"}
		Dim accountTypeBS As String() = {"AcctPay", "AcctRec", "Bank", "Equity", "FixedAsset", "OthAsset", "OthCurrAsset", "OthCurrLiab", "NonPosting"}
	
		Dim accountTypeSignFlip As String() = {"Income", "OthIncome", "AcctPay", "Equity", "OthCurrLiab"}
		
#End Region

Hi Rob

I have tried the following two scripts:

api.Parser.ProcessSQLQuery(si, DbProviderType.OLEDB, connectionName, True , sSQL, False, api.ProcessInfo)

'Get data from source.
Using dbC As DbConnInfo = BRApi.Database.CreateExternalDbConnInfo(si, connectionName)
	dt = BRApi.Database.ExecuteSql(dbC, sSQL, True)
End Using

'Execute the data load
api.Parser.ProcessDataTable(si, dt, False, api.ProcessInfo)

Both work, but both seem to produce the same message in the error log (on a side note, do you know which is the best one to use from a performance point of view?)

When you say chain your exception throwing, is that not what I'm doing here?

Catch ex As Exception
	Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
End Try