Our security team approved only Azure AD Authentication. But, I don't see Azure Active directory authentication options in my ssis 2012 when i try to connect with ado.net source. I...

i got the answer both convert back and forth. Here is the example: 
select dateadd(d,737060 -722815,'1980-1-1')
select datediff(d, 0, '2019-01-01') + 693596
Thanks for trying to answer.

No excel here. sqlserver integer value to normal date and normal date to integer conversion. that integer value is stored in sql server table. I can able to convert using...

Sorry. I forgot to attach sample data file. Please advise the steps to do following scenarios:

1. if amtperact <min_cst of lowest seqnum, then UnitPrice should be updated with...

Thank you. But thing is not sure how to handle other two scenarios
1. if amtperact <min_cst of lowest seqnum, then UnitPrice should be updated with min_cst of lowest of seqnum(1) always.

before they were having only three types charges. Now they can be having having multiple number of charges. that's the reason they removed 1,2,3 concept and generalized with seqnum and...

Current table cp_inv structure: 
finnum, cst1, cst2,cst3,prc1,prc2,prc3, chk_amt1, chk_amt2, chk_amt3 
Logic to update:
Update ProdStg
set unit_cost=case when ci.totcstperacct<ci.cst1 then ci.chk_amt1
when ci.totcstperacct>=ci.prc2 and ci.totcstperacct<ci.cst2 then ci.chk_amt2
when ci.totcstperacct>ci.prc3 then...

Update ProdStg
set unit_cost=case when ch.totcstperacct<(select ch.cst from cp_chk where ch.seqnum=1) then (select ch.chk_amt from cp_chk where ch.seqnum=1)
when ch.totcstperacct>=(select ch.prc from cp_chk where ch.seqnum=2) and ch.totcstperacct<(select ch.cst from cp_chk...

I need another help.
Need to modify the Update statement to include combination two new fields instead of one field

Current table cp_inv structure:
ID, cst1, cst2,cst3,prc1,prc2,prc3, chk_amt1,...

Current table cp_inv structure: 
ID, cst1, cst2,cst3,prc1,prc2,prc3, chk_amt1, chk_amt2, chk_amt3 

New table cp_chk structure:
ID, cst, prc, chk_amt, seq_num
basically 9 columns replaced by 4 columns. Now they removed...

Need to modify the Update statement to include combination two new fields instead of...

Thank you so much Jonathan!!!

Can i use Microsoft power query or third party tools like Alteryx to extract the  unstructured data from excel to sql server? Please advise the best tool i can use?

can i  Master Data Services to import unstructured data to create as tables?