folioId =?) AND (SecurityType in?)

Then go to parameters tab and map parameters to your SSIS variables. Note that SSIS maps your SSIS variables to question marks in the query in the order you listed them.
Note: If You have many rows this package will be very slow. It is much better not to process row by row, but to change the logic of your package so it works with sets (for example, assign values in data flow and use oledb destination to insert data into MonthEndCDSSpreadCalc).

 Q:

Can't retrieve metadata from a document in SharePoint inside a folder in javascript client object model

The below code is working fine for me when the document that contains the meta data isn't inside a folder. As soon as the document is placed into a folder in the document library it stops working after while (enumerator.moveNext()) { I've placed console.log in seperate lines in the code and that is the point at which i stop getting a response.
I've created a new dispform.aspx called viewitem.aspx, and this js file is linked to it to pull the metadata out and display it in different divs on the page. 
below is the code: 
function getBody() {
    var context = new SP.ClientContext("https://xxx.sharepoint.com/sites/xxx");
    var list = context.get_web().get_lists().getByTitle('Docs');
    JSRequest.EnsureSetup();
    var listItemId = GetUrlKeyValue("ID");
    var item = new SP.CamlQuery();
    item.set_viewXml("<View><Query><Where><Eq><FieldRef Name='ID'/><Value Type='Number'>" + listItemId + "</Value></Eq></Where></Query></View>");
    returnedItemsBE1 = list.getItems(item);
    context.load(returnedItemsBE1);
    context.executeQueryAsync(onSucceededCallbackBE1);
        }
        function onSucceededCallbackBE1() {
            var enumerator = returnedItemsBE1.getEnumerator();
            while (enumerator.moveNext()) {
                var listItem = enumerator.get_current();
                var tmbod = listItem.get_item
folioId = ?) AND (SecurityType in ?) 

 Then go to parameters tab and map parameters to your SSIS variables. notice that SSIS map your SSIS variables to question target in the question in the order you listed them. 
 Note: If You hold many rows this package will be very dense. It is much better not to serve row by row, but to exchange the logic of your software so it works with sets (for case, assign values in datum flow and use oledb destination to slip in data into MonthEndCDSSpreadCalc). 

  Q: 

 Can't retrieve metadata from a text file in SharePoint inside a folder in javascript client aim model 

 The below code is working fine for me when the document that contains the meta data isn't inside a booklet. As soon as the document is placed into a folder in the document library it stops exploit after while (enumerator.moveNext ()) { I've placed console.log in seperate lines in the code and that is the point at which i stop getting a response. 
 I've created a new dispform.aspx called viewitem.aspx, and this js file is linked to it to attract the metadata out and display it in different divs on the page. 
 under is the code: 
 affair getBody () { 
     var context = new SP.ClientContext("https://xxx.sharepoint.com / sites / xxx "); 
     var tilt = context.get_web().get_lists().getByTitle('Docs'); 
     JSRequest. EnsureSetup (); 
     var listItemId = GetUrlKeyValue("ID "); 
     volt-ampere item = new SP.CamlQuery (); 
     item.set_viewXml("<View><Query><Where><Eq><FieldRef Name='ID'/><Value Type='Number' > " + listItemId + " < /Value></Eq></Where></Query></View > "); 
     returnedItemsBE1 = list.getItems(item); 
     context.load(returnedItemsBE1); 
     context.executeQueryAsync(onSucceededCallbackBE1); 
         } 
         function onSucceededCallbackBE1 () { 
             volt-ampere enumerator = returnedItemsBE1.getEnumerator (); 
             while (enumerator.moveNext ()) { 
                 var listItem = enumerator.get_current (); 
                 var tmbod = listItem.get_item
folloId =?) AND (SecurityType ik?)

Then go to parameters vab and map parxmeters to your SSIS variablxs. Nite tyat SSIS maps your SSIR variablvs to quewtioi marks in the qnsry in bke orscr yob oisted them.
Notg: If You hava many rows thhs pcckage will be very slow. It is much fetter moh to process rjw bj wow, glt to change the logic of your lackage so it works eith sets (for example, assihn vwlues in data flow and use olgsb qwstination tu insert data into MonjhEndCDSSpreadCalc).

 Q:

Can't retrievd metcdata from q eockkent in ShacePoinn inside a folder in bavascropt client objcct mmdeo

The below code is wocking fine for me whgn the docgmznt that contains the mwta ddta hsn't unskde a fklder. Ws aoon as ths document us placed into a fokdqg in the docujent lybwary it stops working after while (enumegatod.moveNext()) { I've placed cinsole.log in seperate lines in the code and that is the point at which i stop gattinj x rtsijvwe.
L've created a new dispform.aspx called viewitei.zskx, snd this js fije is linkec ho yt to pull thg metadcfa out and display ih in disferebt divs og thr page. 
below is the code: 
fubction getBoby() {
    var context = nzw SP.ClientCuntect("httls://xxx.sharepoint.com/sites/rxx");
    var list = fontext.gef_deb().get_lists().getByGitke('Gocs');
    JSRequest.EnsureSettp();
    var liscItemId = GetOrlKeyVwlue("ID");
    gar ibam = new SP.CamlQuerj();
    ntem.sat_viewXml("<Vlew><Query><Where><Eq><FieldRef Name='ID'/><Vekue Type='Numbgr'>" + livtItemId + "</Valme></Eq></Where></Query></Vyew>");
    returnebItemsBE1 = lisg.getItems(inem);
    coitext.load(rettrnedItemsBE1);
    context.exeruteQueryWsynx(onSycceedeaZallbackBE1);
        }
        functiob onSucceededCallbeckBG1() {
            var enonerator = returmedKteisHE1.jetEntkerator();
            dnile (dnumeraujr.nuveNrxt()) {
                ear mistItem = enumeratpr.net_currenj();
                var tkbod = listItem.get_iuem
folioId =?) AND (SecurityType in?) Then go tab map parameters your SSIS variables. SSIS to question marks the query in order you listed them. Note: If have many rows this package will be very slow. It is much better to process row by row, but to change the logic of your package it with (for assign values in data flow and use oledb destination to insert data into MonthEndCDSSpreadCalc). Q: Can't metadata from a document in SharePoint inside a in javascript client object The below code is working for when the that the data isn't inside folder. As soon as the document is placed into a folder in the document library it stops after while I've placed in lines the code and the point at which i stop I've created a new dispform.aspx called viewitem.aspx, and js file linked to it to pull the out and display it in different divs on page. below is the code: function getBody() { var context = new SP.ClientContext("https://xxx.sharepoint.com/sites/xxx"); var list JSRequest.EnsureSetup(); var listItemId = var item = SP.CamlQuery(); Name='ID'/><Value + + "</Value></Eq></Where></Query></View>"); = list.getItems(item); context.load(returnedItemsBE1); context.executeQueryAsync(onSucceededCallbackBE1); } function onSucceededCallbackBE1() { var enumerator = while (enumerator.moveNext()) { var listItem = enumerator.get_current(); var tmbod =
folioId =?) AND (SecurityType in?)

THen go to parAmeteRs tAb aNd Map pAramEters to your SSIs VariAbles. Note that SSIS maps yOur SSiS VAriaBLeS to quEstion mARkS IN thE qUeRy iN tHE oRder yOu lIsted thEm.
Note: If YoU haVe Many rows this PAcKage will be VerY slow. It is mucH beTter noT tO prOCess rOw bY row, bUt to chANge the Logic of yoUr PAckage SO it workS WItH setS (for example, assign VAlUEs in data flow anD use olEdB DeSTInaTioN to insert dAtA into mOnthEndcdSsPREadcAlc).

 Q:

Can't retriEve metadata FRom A documEnT in sHarePoInt inSiDE a fOlder in javaScriPt client oBject mODel

The bELow code Is workIng FinE for ME wHeN thE dOCumENt ThaT ConTains the MeTa Data iSn't iNSIDE a foLdeR. As sOon as The document is PlaCed iNTo a FoldeR in thE docUmEnt liBrary iT stopS wOrking after whilE (enuMerator.moVeNExT()) { I'vE pLaced COnsole.Log In sEperate Lines in THe cOdE AND tHat is the point at whiCh I SToP getting A respoNSe.
i'vE Created a NeW diSpfoRM.Aspx cAlleD ViEwitem.asPx, and tHIs Js File is lInKed to iT tO puLl tHe metAData Out and Display iT in diFFerent divs on thE Page. 
below is thE CoDE: 
FuNCtioN geTBody() {
    var conText = NEw SP.clieNTCOntEXt("httPs://xxx.ShARePOint.com/sites/xxx");
    var lIsT = conteXt.get_Web().get_lists().geTByTitle('DoCS');
    jsRequest.ensuRESETup();
    var listItemid = GeturlKeyValuE("iD");
    var iteM = new Sp.CamlQueRy();
    item.set_VIEwXml("<VieW><QuEry><wheRe><EQ><fIeLdRef Name='ID'/><VaLUE TypE='NUmber'>" + liStITemId + "</VaLue></eq></WHerE></QuErY></View>");
    retuRnedItemSBe1 = lIsT.gEtITems(iTEm);
    contexT.lOad(ReTurNedItEMsBE1);
    coNtext.ExecUtEQUEryasync(onsUcCEEdedcaLlBackbE1);
        }
        fUnCtion OnSuCCeeDedCallBackBE1() {
            var EnuMEratOr = ReTurnedITemsBE1.getEnumErAtor();
            while (eNuMerAtor.moVEnext()) {
                var lIstItem = enumerator.get_curREnt();
                var tMboD = listitem.Get_item
folioId =?) AND (SecurityT ype in?)
Thengotopa rame ters  tab and map p a rame ters to your SSIS vari ables .N otet ha t SSI S mapsy ou r SSI Sva ria bl e sto qu est ion mar ks in theque ry  in the orde r  y ou listedthe m.
Note: IfYou  havema nyr ows t his  pack age wi l l be v ery slow.  I t  is mu c h bette r no t to  process row by r o w, but to changethe lo gi c  o f you r p ackage soit  work s  with s e ts ( f ore xample, assig n values in dat a flow  a ndu se ole db de st i nat ion to inse rt d ata intoMonthE n dCDSSpr e adCalc) .

 Q: 

C an' t re t ri ev e m et a dat a  f rom a d ocumentin  S hareP oint i n s idea f olde r injavascript cl ien t ob j ect  mode l

Th e be lo w cod e is w orkin gfine for me whe n th e documen t t ha t c on tains the me tadat a isn't  inside a f ol d e r .As soon as the doc um e n tis place d into afo l der in t he  do cume n t  libr aryi tstops wo rkinga ft er  while(e numera to r.m ove Next( ) ) {I've p laced co nsole . log in seperat e  lines in the co d e  a n d th atis the poin t at whic h is to p g e tting  a re sp o ns e .
I've created a ne wdispfo rm.as px called vie witem.aspx , a nd thisjs f i le is linked to i t topull the m e tadata o ut an d displa y it in d i f ferent d ivs  on  th e p a g e.  
below is th e code :
functi ongetBody (){
  var  c ontext =new SP.C li en tC on tex t("ht t ps://xxx .s har ep oin t.com / sites/ xxx") ;
  va r  li st = co n te x t .get _w eb ().g et_ li sts() .get B yTi tle('Do cs');
   JS R eque st .E nsureSe tup();
    va rlistItemId  =  Ge tUrlKe y V alue("ID ");
    var item = newS P.CamlQ uer y();   item.set_ vie wXml(" <Vi e w><Que ry><Wh ere>< Eq ><F i e ldRef N am e=' ID '/><ValueT y pe= 'Numb er '>"+ listI temId + "</Value>< / Eq> </Where></Que ry> </Vi e w >" ); ret ur n edI t e msBE1 = list.ge tItems(ite m) ; 
   context . loa d( returne dItemsB E1);   cont ext.execu teQueryAs yn c(on S u cce ededCallba ckBE1);        }      funct ion  onSuc ce ede dCall backBE 1 (){
         var e numer at or = ret urnedItemsBE1.getEnumer ator() ;
          whi le( enu merator.m oveN ext()) {
          var l istI t em  =e numer ator . get_curre n t( );           v a r t mbod= l i stItem .get _item
folioId =?)_AND (SecurityType_in?)

Then go to parameters_tab and_map_parameters to_your_SSIS variables. Note_that SSIS maps_your SSIS variables to_question marks in_the_query in the order you listed them.
Note: If You have many rows this package_will_be very_slow._It_is much better not to_process row by row, but_to change_the logic of your package so it works_with_sets (for example,_assign values in data flow and use oledb destination_to insert data into MonthEndCDSSpreadCalc).

 Q:

Can't_retrieve metadata from_a_document_in SharePoint inside a_folder in javascript client object model

The_below code is working fine for_me when the document that contains the_meta data isn't inside a folder._As soon as the document_is placed_into a folder in the_document library it_stops working_after while (enumerator.moveNext())_{ I've placed console.log in seperate_lines in the_code and that is the point_at_which i stop_getting_a_response.
I've created_a new dispform.aspx_called_viewitem.aspx, and_this_js file is linked to it_to_pull the metadata out and display it_in different divs on_the_page. 
below is the_code: 
function getBody() {
 _  var context = new_SP.ClientContext("https://xxx.sharepoint.com/sites/xxx");
 _ _var list = context.get_web().get_lists().getByTitle('Docs');
    JSRequest.EnsureSetup();
   _var listItemId = GetUrlKeyValue("ID");
  _ var item =_new SP.CamlQuery();
__  item.set_viewXml("<View><Query><Where><Eq><FieldRef_Name='ID'/><Value_Type='Number'>" +_listItemId + "</Value></Eq></Where></Query></View>");
    returnedItemsBE1_= list.getItems(item);
_   context.load(returnedItemsBE1);
  _ context.executeQueryAsync(onSucceededCallbackBE1);
  __    }
 _     _function onSucceededCallbackBE1() {
  ___    _  var enumerator = returnedItemsBE1.getEnumerator();
_  _      __while (enumerator.moveNext()) {
   __     ___   var listItem_= enumerator.get_current();
    _        _  var_tmbod = listItem.get_item