This was a life saver. Thank you very much!

Excellent. Thank you both. This is awesome.

Thanks Phil. This defintiely looks much better.

All the rates are now coming in one column. (image attached).

What I want is to look like this. (Ignore firs USD:1 from the rates)

sucess...

I knew that would be coming. Sorry about that. SO, here's the DDL with sample data.

IF OBJECT_ID('TempDB..#PlanTargets','U') IS NOT NULL

DROP TABLE #PlanTargets

IF OBJECT_ID('TempDB..#InvLine','U') IS NOT NULL

DROP TABLE #InvLine

CREATE TABLE #PlanTargets(

[CSegm]...

Thank you for your response. That makes sense. But why would Azure Data Studio shows the perfect results but SSMS don't?

Yeah, hoping that the script will execute on the remote server.

DimInvoice has 33925277 rows. I am not able to finish the query in SSMS at all. Running all sorts of issues. I believe it pulls the data but to deliver...

view attached. It takes 2 hours to run. I'll try to run when there is not much activity in the server.

query attached.  stats look good.

Interesting. It works fine on my machine. When I double click on it it pulls up on my SSMS. It was saved using Plan Exploer if that helps.

I'm attaching the...

Looks like this one

https://github.com/RamblingCookieMonster/PowerShell/blob/master/Out-DataTable.ps1

Thanks. Do you have example (script) by any chance?

My problem is OPENROWSET ... BULK ... SINGLE_CLOB retruns everything in 1 column and I wouldn't know where the data begins from?...

Sometimes new additonal columns too.

I am using Lookup Activity to connect to Source file and trying to pass the whole content of the file through parameter of stored proc as a string. Stored proc...

Please look at both attached files. JsonJPG is from my computer and JSONJpg1JPG is from plural sight course. Why am I not seeing JSON option in my ADF?  Particulary Parse...