I did have the same problem with excels exported from SSRS. Haven't tried to fix it beyond opening the excel and saving it again with excel

• This reply was modified 5 years, 10 months ago by Jo Pattyn.

Which version of SSMS is it? because is has been decoupled from the sql server installation. 18.4 , ... ?

--to be validated
--cte or tablealias for selfjoin
WITH TABLEDATA AS
(
SELECT ...
FROM TABLE_DATA
)
SELECT TYTD.COLUMNS, TMTD.COLUMNS
FROM TABLEDATA TYTD
LEFT JOIN TABLEDATA TMTD
ON TYTD.NAME=TMTD.NAME
AND TYTD.COMPANY = TMTD.COMPANY
AND TMTD.Flag='MTD'
...
WHERE TYTD.Flag='YTD'; 
--also possible
SELECT YTD.columns,...

• This reply was modified 5 years, 10 months ago by Jo Pattyn. Reason: where flag

Reasons to use SSIS:

• Already made a large investment
• Drag-drop synchronisation. If A+B complete, run C
• Microsoft Oracle SSIS - driver (speed improvement over the normal Oracle OLE DB driver)

...

I use https://sqlserverbuilds.blogspot.com/ to track the latest builds.

You can also use https://www.sqlservercentral.com/articles/sql-server-build-lists or https://sqlserverupdates.com/

For 2016 it is SP2  + CU 11

Didn't get much improvement with the current Oracle OLEDB driver. Even with balanced data distrubutor.

The new microsoft oracle connecter is promising (SQL Server 2019 CU1+).

https://techcommunity.microsoft.com/t5/sql-server-integration-services/microsoft-connector-for-oracle-is-released-for-sql-server-2019/ba-p/565923

Processing speed goes up from...

We try to implement them every 2 months. First a testing period of 1 month in dev and acceptance. So far the updates didn't break anything

Happy New Year. 2020 looks promising, sofar SSIS started working again in VS2019

Happy holidays! Awaiting the reviews of the lastest star wars. Already missed Han Solo

Odd question, have you contacted the CRM-provider about the slowness?

Testcase

Use case:
Deleted primary key detection
Method: Copy PK from Oracle to SQL Server and compare

Problem: starts fast but slows in speed every fetch?
Expected duration: 3000 seconds , network...

Hmm, contact microsoft support? Assuming the product is https://docs.microsoft.com/en-us/microsoftteams/turning-on-and-using-call-quality-dashboard

You could explore the Azure datafactory, flows and databricks

Thanks Steve Jones for the article. After uninstalling native client the 2019 worked

Where is that passage "Not if using Standard edition as clearly stated on the licensing guide" in the licensing guide?