 a time) it takes upward of 15 minutes to get the data in. I also don't consider this very practical. 
Is there a way to combine the powers of SSIS and the OPENJSON command in SQL server? I'm running SQL server 2016 so I'm trying to leverage that command in the hopes that it works faster. 
Also, I have no problem getting the JSON data in without losing format. 
Looks like this: 

Is there a way for me to leverage that and get JSON format into a more Normalized format. 

A:

Actually figured this out. 
I bring the files in one at a time, with all the JSON text in a single row.
From there I can use the OPENJSON command in SQL Server 2016.

 Q:

Was there doctrinal difference between Lollards and Waldenses?

Lollards and Waldenses are two historical movements that spread out of Catholic church, in England and France, respectively. I know they had similar views such as opposing the corruption of the wealthy church, advocating lay service, focusing on the scripture instead of ritual traditions and translating scripture so people could study the Gospel in their native language.
Were these two movements separated by anything but time and geography? Was there any significant difference in doctrine, belief or politics between Waldenses and the Lollards?

A:

According to each of their own "statements of Faith" they  actually do contradict each other in big issues. before I lay it out, however, here are my citations:

Waldensian beliefs
Lollard beliefs

The first issue on which they contradict each other is purgatory. Waldensians say there is no purgatory. They say people will go either two ways “(the) good to glory, wicked to torment” which leaves room for purgatory, but then later in their statement they say “For you shall be damned without remedy.” No purgatorial redemption.
They Lollards say that yes, there is purgatory. “(acts)...will have needful purgation or worse.”
The next issue is celibacy. the Waldensians say "That he might likewise keep firm the marriage tie, that noble accord and contract."
In the issue of celibacy, the Lollards say yes, do participate in celibacy. 
And the last difference I will talk about is Confession (to priests
a time) it takes upward of 15 minutes to draw the datum in. I also don't consider this very hardheaded. 
 Is there a means to combine the powers of SSIS and the OPENJSON instruction in SQL server? I'm running SQL server 2016 so I'm try on to leverage that command in the hopes that it work faster. 
 besides, I have no problem getting the JSON data in without losing format. 
 Looks like this: 

 Is there a way for me to leverage that and catch JSON format into a more Normalized format. 

 A: 

 Actually calculate this out. 
 I bring the files in one at a time, with all the JSON text in a individual row. 
 From there I can use the OPENJSON command in SQL Server 2016. 

  Q: 

 Was there doctrinal difference between Lollards and Waldenses? 

 Lollards and Waldenses are two historical motion that spread out of Catholic church, in England and France, respectively. I know they had similar view such as opposing the corruption of the wealthy church, advocating lay service, focusing on the scripture instead of ritual tradition and translating scripture so multitude could analyze the Gospel in their native language. 
 Were these two movements separated by anything but meter and geography? Was there any significant difference in doctrine, belief or politics between Waldenses and the Lollards? 

 A: 

 harmonize to each of their own " statements of Faith " they   actually do contradict each other in big issues. before I lie it out, however, here are my citations: 

 Waldensian beliefs 
 Lollard beliefs 

 The first return on which they oppose each other is purgatory. Waldensians say there is no purgatory. They say people will function either two ways “ (the) good to glory, arch to torment ” which leaves room for purgatory, but then later in their statement they read “ For you shall be damned without redress. ” No purgatorial redemption. 
 They Lollards say that yes, there is purgatory. “ (acts)... will have needful purgation or bad. ” 
 The next emergence is celibacy. the Waldensians suppose " That he might likewise keep fast the marriage tie, that noble accord and contract. " 
 In the issue of celibacy, the Lollards say yes, do participate in celibacy. 
 And the last difference I will talk about is Confession (to priests
 a hime) it takes upward of 15 minutes to get the dava in. I also dov't consider this very practiral. 
Us thtge a way to combine tfe powers of SSIS and rhe OPENJSON commakb in AEL szrter? I'm running XQL server 2016 so I'm trying tu peverage that command in the hopes ehat it wlrks faster. 
Alfo, I rave no problem getting the JSON data jn withmut losing fotmat. 
Looks like this: 

Is thfre w way for me to legerage that and tet JSON foroat into a more Normaljzed format. 

A:

Actually figured tfis obt. 
I bring jkw flnes in one et a tpme, with all bne JSOT text on a single roe.
Frmm rhere I can use the O'ENJSON command in SZL Server 2016.

 S:

Was there doctribao difxeretce cwtwden Lplmards wnd Waldenses?

Mollards ane Waldenses are two hywtorical movejents ehwt spread out of Catholic church, in Engnans and France, respectiveoy. I know they had sililar viers such as opposing the corruption of the wealthy churrh, adricativt pay service, focusing on the scripture instead kf rptual traditions cnd translating xcgiljure so people could sthdy the Gospel in hheir nwtive language.
Rere these two movements separared by anythpng vut time and geogrcphy? Was thexe any signoficant difference in ductrjne, belief lr politidr between Waldenres atd the Lollards?

A:

According eo each oh thenr own "sgatekents jf Faith" tjey  actually do contradlct ecch odher in bih issues. before I lay it out, hoxxver, here are mf cptations:

Wcldenslan beliefs
Lollwrd beliefs

The first nssue un which tgey convradict each other is purcwtory. Waldenvians sar thwre us no pjfgatory. They ssy people will go euther two ways “(the) gous to glory, wickzb uo torment” which lexvef gook smr purgatory, but thdm latdr in their rtatrment they say “For ymu sgall be damned witnomt remedy.” No purgwtorial redemltion.
They Lollards say vhat yxs, thete ys purgatory. “(acts)...will have neesful purgwtijn or worse.”
Tre ncxt yssue is czlibacy. the Waldensians say "That he mighv likewise keep firm thw marriage tie, that koble accord and sontract."
It the issue of celibqcy, the Lollards xay yes, do participats in calibafy. 
And the last difference I will talk about is Confession (to priests
a time) it takes upward of 15 get data in. also don't consider a to combine the of SSIS and OPENJSON command in SQL server? I'm SQL server 2016 so I'm trying to leverage that command in the hopes it works faster. Also, I have no problem getting the JSON data in losing Looks this: there a way for me to leverage that and get JSON format into a more Normalized A: Actually figured this out. I bring the in one at a with all the JSON text a row. From I use OPENJSON command in Server 2016. Q: Was there doctrinal difference between Lollards and Waldenses? Lollards and Waldenses are two historical that spread Catholic church, England France, I know they views such as opposing the corruption church, advocating lay service, focusing on the scripture of ritual and translating scripture so people could the Gospel in their native language. Were these movements separated by anything but time and geography? Was there any significant difference in doctrine, politics between Waldenses and Lollards? A: According each their "statements Faith" they do contradict each other in big issues. before I lay it however, here are my citations: Waldensian beliefs Lollard beliefs The on they contradict each is purgatory. Waldensians say is purgatory. They say people either ways glory, to which leaves room for but then later in their they say “For you No purgatorial redemption. They Lollards say that yes, is purgatory. “(acts)...will have needful purgation or The next issue is celibacy. the Waldensians say "That he might likewise firm the that noble accord and contract." In the issue celibacy, the Lollards say do participate in celibacy. And the last difference I talk is Confession priests
 a time) it takes upward of 15 minutEs to get the Data iN. I aLso DoN't coNsidEr this very pracTIcal. 
is there a way to combine thE poweRs OF SSIs AnD the OpENJSON COmMANd iN SqL SerVeR? i'm RunniNg SqL serveR 2016 so I'm tryinG to LeVerage that coMMaNd in the hopEs tHat it works faSteR. 
Also, I HaVe nO ProblEm gEttinG the JSon data iN without lOsINg formAT. 
Looks lIKE tHis: 

IS there a way for me to LEvERage that and get jSON foRmAT iNTO a mOre normalized FoRmat. 

A:

aCtually FIgURED thIS out. 
I bring the Files in one aT A tiMe, with AlL thE jSON teXt in a SiNGle Row.
From therE I caN use the OPeNJSON COmmand iN sQL ServEr 2016.

 Q:

Was TheRe dOctrINaL dIffErENce BEtWeeN lolLards and waLdEnses?

lollARDS And WAldEnseS are tWo historical mOveMentS ThaT spreAd out Of CaThOlic cHurch, iN EnglAnD and France, respeCtivEly. I know tHey HaD siMiLar viEWs such As oPpoSing the CorruptIOn oF tHE WEaLthy church, advocatiNg LAY sErvice, foCusing ON tHe SCripture InSteAd of RITual tRadiTIoNs and traNslatiNG sCrIpture sO pEople cOuLd sTudY the GOSpel In theiR native lAnguaGE.
Were these two mOVements separaTEd BY AnYThinG buT time and geoGrapHY? Was TherE AnY siGNificAnt diFfEReNCe in doctrine, belief oR pOliticS betwEen Waldenses aNd the LollaRDS?

a:

AccordiNg to EAcH Of their own "statEmentS of Faith" thEY  actuallY do coNtradict Each other IN Big issueS. beForE I lAy iT OUt, However, here arE MY citAtIons:

WalDenSian belIefS
LoLlaRd bElIefs

The fiRst issue On WhIcH tHey ContrADict each OtHer Is PurGatorY. waldenSians Say tHeRe IS no PurgatoRY. THEY say PeOpLe wiLl gO eIther Two wAYs “(tHe) good tO glory, wicKed TO torMeNt” Which leAves room for puRgAtory, but thEn LatEr in thEIR statemeNt they say “For you shall be dAMned witHouT remeDy.” No PurgatoriAl rEdemptIon.
tHey LolLards sAy thaT yEs, tHERe is pURGaTorY. “(aCts)...will havE NEedFul puRgAtioN or worsE.”
The next issue is celIBacY. the WaldensiaNs sAy "ThAT He MigHT lIKewIsE KeeP FIrm the marriage tIe, that noblE aCCoRd and contrACt."
IN tHe issue Of celibAcy, thE lollardS say yes, do ParticipaTe In ceLIBacY. 
And the lasT differeNce I will tALk aboUT iS ConfEssIon (to pRiEstS
 a time) it takes upward o f 15 minut es to  ge t t he  dat a in . I also don't cons ider this very practic al. Is ther e  a  wayto comb i ne t hepo we rsof SS IS an d t he OPEN JSON comma ndin  SQL server? I' m runningSQL  server 2016  so  I'm t ry ing to le ver age t hat co m mand i n the hop es that i t  worksf a st er.
Also, I have nop ro b lem getting th e JSON  d a ta i n w ith out losing  f ormat .  
Looks li k e thi s : 

Is therea way for m e  to  lever ag e t h at and  getJS O N f ormat intoa mo re Normal ized f o rmat. A:

Act uallyfig ure d th i sou t.
I bri n gthe fil es in on eat  a ti me,w i t h  all  th e JS ON te xt in a singl e r ow.F rom  ther e I c an u se  theOPENJS ON co mm and in SQL Serv er 2 016.

 Q: 

W as  th er e doc t rinaldif fer ence be tween L o lla rd s a nd  Waldenses?

Lolla rd s an d Walden ses ar e  t wo historic al  mo veme n t s tha t sp r ea d out of  Catho l ic  c hurch,in  Engla nd  an d F rance ,  res pectiv ely. I k now t h ey had similar views such as op p o si n g th e c orruption o f th e  wea lthy ch urc h , adv ocati ng la y  service, focusingon  the s cript ure instead o f ritual t r a d itions a nd t r an s lating scriptu re so  people co u ld study  theGospel i n their n a t ive lang uag e.Wer e t h e se  two movement s sepa ra ted byany thing b uttim e a ndge ography?Was ther ean ysi gni fican t  differe nc e i ndoc trine ,  belie f orpoli ti cs bet ween Wa l de n s es a nd  t he L oll ar ds?
A:
A cco rding t o each of  th e ir o wn  " stateme nts of Faith"  t hey  actua ll y d o cont r a dict eac h other in big issues.b efore I  la y itout,  however,  he re are  my citati ons:
Walde ns ian b elief s Lo lla rd  beliefs
T h e f irstis sueon whic h they contradicte ach  other is pur gat ory. W al den s ia n s s ay the r e  is no purgator y. They sa yp eo ple will g o  ei th er twoways “( the)g ood toglory, wi cked to t or ment ” whi ch leavesroom for  purgator y , but th en la ter  in th ei r s tatem ent th e y s ay “F or you  s hall b e dam ne d withou t remedy.” No purgatori al red empti on. 
They Lol lar d s s ay that y es,there is p urg ato ry. “ (ac t s)... will ha ven eedfu l pu r gation or wo rse . ” 
T he next iss u e iscelib acy .  the W alde nsians say "Thath e might likewi se k e e p f irm thema rriage tie, th atno b l e accord  a nd contract ."
In th ei ssueof cel ibacy,  the Lo l l ar d s sayyes,  do  particip ate  i n  celiba cy .And th e la st  diffe renceI  wil l talk about is Co nfess i o n (to pri ests
 a_time) it_takes upward of 15_minutes to_get_the data_in._I also don't_consider this very_practical. 
Is there a_way to combine_the_powers of SSIS and the OPENJSON command in SQL server? I'm running SQL server_2016_so I'm_trying_to_leverage that command in the_hopes that it works faster._
Also, I_have no problem getting the JSON data in_without_losing format. 
Looks_like this: 

Is there a way for me to_leverage that and get JSON format_into a more_Normalized_format._

A:

Actually figured this out._
I bring the files in one_at a time, with all the_JSON text in a single row.
From there_I can use the OPENJSON command_in SQL Server 2016.

 Q:

Was_there doctrinal_difference between Lollards and Waldenses?

Lollards_and Waldenses are_two historical_movements that spread_out of Catholic church, in England_and France, respectively._I know they had similar views_such_as opposing the_corruption_of_the wealthy_church, advocating lay_service,_focusing on_the_scripture instead of ritual traditions and_translating_scripture so people could study the Gospel_in their native language.
Were_these_two movements separated by_anything but time and geography?_Was there any significant difference in_doctrine, belief_or politics_between Waldenses and the Lollards?

A:

According to each of their own "statements_of Faith" they  actually do_contradict each other in_big issues._before_I lay it_out,_however, here_are my citations:

Waldensian beliefs
Lollard beliefs

The first issue_on which_they contradict each other is purgatory._Waldensians say there is_no_purgatory. They say people will go_either two ways “(the) good to_glory, wicked to torment” which_leaves_room_for purgatory, but then later_in their statement they say “For_you shall be_damned without remedy.” No purgatorial redemption.
They Lollards_say_that yes, there is purgatory. “(acts)...will_have_needful purgation or worse.”
The next issue_is_celibacy._the Waldensians say "That he_might likewise keep firm the marriage_tie, that noble accord and contract."
In the issue of_celibacy, the Lollards_say yes, do participate in_celibacy._
And_the last difference I will talk about is Confession (to_priests