update tbl_IMPORT_ProductDataEnrichment set msdsURL = '#_sourceLink#' + msdsfileName where eai_batchid = and nullif(msdsfileName,'') is not null and nullif(msdsURL,'') is null and msdsfileName not like '%inboundFTP%'

Succeeded:#CFFTP.Succeeded#

errorCode:#cfftp.errorCode#

errorText:#cfftp.errorText#

select stage.fse_skuid, stage.fse_mfrid, stage.MfrSkuCode, stage.GTINCase, stage.EANUPC, stage.MSDSFileName, stage.MSDSURL, mfr.mfrAbbrev_Name from tbl_IMPORT_ProductDataEnrichment stage inner join tblManufacturers mfr on ( stage.fse_mfrid = mfr.mfr_id ) where stage.eai_batchId = and stage.fse_skuid IS NOT NULL and coalesce(stage.fse_importStatus,'') NOT LIKE '%SKIP%' select categoryId from tbl_PRD_RepositoryCategories where containerType = 'SKU' and ownerId = 0 and ownerType = '*' and categoryDescription = 'MSDS_SHEET' select l.imgPath, l.ImgName, l.ImgExt from tbl_PRD_REpository r with (nolock) inner join qry_ContentLookup l with (nolock) on r.contentid = l.contentid where r.OwnerType = and r.ownerid = and r.category = 44 and r.containerType = 'SKU' and r.containerId =

#qry_getStagingDocs.MSDSFileName#[#cfftp.errorCode# - #cfftp.errorText#]

Succeeded:#CFFTP.Succeeded#

errorCode:#cfftp.errorCode#

errorText:#cfftp.errorText#

select * from qryFolderExists where name = ;