My query that I am running on my Custom SQL Inbound Service has columns that are larger than the typical string length. How do I enlarge the SQL Snapshot Column limitations 

Class osuwmc.Epic.Clarity.DepartmentMaster Extends %Persistent [ DdlAllowed ]
{
Parameter USEEXTENTSET = 1;
Property CostCenter As %String(MAXLEN = 15) [ SqlColumnNumber = 2 ];
Property ID As %String [ Required, SqlColumnNumber = 3 ];
Index IDIndex On ID;
Property Abbr As %String(MAXLEN = 20) [ SqlColumnNumber = 4 ];
Property Name As %String(MAXLEN = 254) [ SqlColumnNumber = 5 ];
Property ExternalName As %String(MAXLEN = 254) [ SqlColumnNumber = 6 ];
Property PhoneNumber As %String(MAXLEN = 254) [ SqlColumnNumber = 7 ];
Property ApptPhone As %String(MAXLEN = 20) [ SqlColumnNumber = 8 ];
Property FaxNumber As %String(MAXLEN = 20) [ SqlColumnNumber = 9 ];
Property Address1 As %String(MAXLEN = 254) [ SqlColumnNumber = 10 ];
Property Address2 As %String(MAXLEN = 254) [ SqlColumnNumber = 11 ];
Property City As %String(MAXLEN = 254) [ SqlColumnNumber = 12 ];
Property Zip As %String(MAXLEN = 254) [ SqlColumnNumber = 13 ];
Property Specialty As %String(MAXLEN = 50) [ SqlColumnNumber = 14 ];
Property RevLocID As %String [ SqlColumnNumber = 15 ];
Property RevLocName As %String(MAXLEN = 200) [ SqlColumnNumber = 16 ];
Property BuildingCategoryID As %String(MAXLEN = 66) [ SqlColumnNumber = 17 ];
Property BuildingName As %String(MAXLEN = 254) [ SqlColumnNumber = 18 ];
Property DepCategoryTypeID As %String(MAXLEN = 66) [ SqlColumnNumber = 19 ];
Property DepType As %String(MAXLEN = 254) [ SqlColumnNumber = 20 ];
Property Center As %String(MAXLEN = 254) [ SqlColumnNumber = 21 ];
Index BitmapExtent [ Extent, Type = bitmap .....

Class osuwmc.Epic.Clarity.SelectEpicClarityDepartment Extends Ens.BusinessService [ ClassType = "", ProcedureBlock ]
{
Parameter ADAPTER = "EnsLib.SQL.InboundAdapter";
Parameter REQUESTCLASSES As %String = "EnsLib.SQL.Snapshot";
Property InitDSN As %String;
Method OnInit() As %Status
{
  Set ..InitDSN = ..Adapter.DSN
  //Set ..Adapter.ConnectAttrs = "QueryTimeout:45" ; try this too just in case...
  set pInput = ##class(EnsLib.SQL.Snapshot).%New()
  set pInput.MaxRowsToGet = -1
  set tSC = rs.Insert(pInput)
  Quit $$$OK
}

Method OnProcessInput(pInput As EnsLib.SQL.Snapshot, pOutput As %RegisteredObject) As %Status
{
  set req=##class(osuwmc.Epic.Clarity.DepartmentMaster).%New()
  set req.CostCenter = pInput.Get("CostCenter")
  set req.ID = pInput.Get("ID")
  set req.Abbr = pInput.Get("Abbr")
  set req.Name = pInput.Get("Name")
  set req.ExternalName = pInput.Get("ExternalName")
  set req.PhoneNumber = pInput.Get("PhoneNumber")
  set req.ApptPhone = pInput.Get("ApptPhone")
  set req.FaxNumber = pInput.Get("FaxNumber")
  set req.Address1 = pInput.Get("Address1")
  set req.Address2 = pInput.Get("Address2")
  set req.City = pInput.Get("City")
  set req.Zip = pInput.Get("Zip")
  set req.Specialty = pInput.Get("Specialty")
  set req.RevLocID = pInput.Get("RevLocID")
  set req.RevLocName= pInput.Get("RevLocName")
  set req.BuildingCategoryID = pInput.Get("BuildingCategoryID")
  set req.BuildingName = pInput.Get("BuildingName")
  set req.DepCategoryTypeID = pInput.Get("DepCategoryTypeID")
  set req.DepType = pInput.Get("DepType")
  set req.Center = pInput.Get("Center")
  set status = req.%Save()
  IF $$$ISERR(status){
    Write "Error saving data: ", status, !
    }
    Else {
        Write "Data inserted successfully!", !
    }
    quit status
}
}

For example.... ExternalName is not getting populated correctly and is NULL when I look at the table in SQL.

I have the need to query an external database and write the result set/snapshot to an internal %Persistent [ DdlAllowed ] table that I built. I have built inbound SQL Services before and write them externally to replace SSIS jobs, but how would querying a database via a Service and writing the data to an internal table work?

Can I just take the inbound query structure and write it to the class file of the internal table in a DTL? If so, what would be the Target? Or does this need to be done within a BPL as a Code block?