select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = and fsltablecode = and tradeEnabled = 'Y' and nullif( tradeNbr, '' ) is null select opr.tradeNbr, opr.companyName, opr.address, opr.city, opr.state, opr.zipcode, c.countryAbbrev as utCountriesCountryAbbrev, seg.mainSegment as oprSegmentsMainSegment, seg.subSegment as oprSegmentsSubSegment from tbl_OPR_ClientOperators opr with (nolock) inner join tbl_CHO_Operators cho with (nolock) on cho.cho_id = opr.fsl_choId left outer join tbl_OPR_Segments seg with (nolock) on seg.segmentId = cho.cho_segmentId left outer join tbl_UT_Countries c with (nolock) on c.countryId = opr.countryId where opr.ownerId = and opr.fsltablecode = and opr.crmActive = 'Y' and opr.tradeEnabled = 'Y' and cho.cho_type != 'U' order by opr.companyName select formatId from tbl_EAI_inboundFileFormats with (nolock) where ownerId = and ownerType = and formatName = select formatId from tbl_EAI_inboundFileFormats with (nolock) where ownerId = 0 and ownerType = and formatName =

#qmd_export.recordCount# rows written to #htmleditformat( _exportFileName )#

 update tbl_EAI_inboundBatches set fileName = where batchId = and ownerId = and ownerType = select ftpDirectory, ftpPassword, ftpServer, ftpUserName, ftpPort, ftpFingerprint from tbl_EAI_InboundFTPSources with (nolock) where ownerId = and ownerType = and outbound = 'Y' and connectionName like '%TO_BOSTON%' and ftpServer = 'ftp.blacksmithapplications.com' and ftpDirectory like and nullif( ftpFingerprint, '' ) is not null

#htmleditformat( _remoteFile )# sent to sftp:#htmleditformat( qmd_ftpSource.ftpUserName)#@#htmleditformat( qmd_ftpSource.ftpServer )#/#htmleditformat( qmd_ftpSource.ftpDirectory )#

File not sent, unable to connect to #htmleditformat( qmd_ftpSource.ftpServer )#/#htmleditformat( qmd_ftpSource.ftpDirectory )#

An error occurred while sending the file to #htmleditformat( qmd_ftpSource.ftpServer )#/#htmleditformat( qmd_ftpSource.ftpDirectory )#

File not sent, no outbound FTP source for #htmleditformat( _ftpDirectory )#

 
#htmleditformat( _extractR.sql )#