Semicolon is missing before the WITH, ohterwise ok

Compared with Power Query from Excel or Power BI it really seems hard to handle csv. SSIS is older. But meanwhile you can use a Power Query Data Source in...

I had the same experiences at sometimes – Maybe because I’m more of a SQL guy and not 100% familiar with the SSIS tools. So most times I prefer using...

You can just insert the data you need in a table. You can uses joins and identify easily before and after values.  I think attaching the data outside the database...

I sometimes backup the table inside the database from the select statement. So it’s relatively easy to compare and - if necessary restore  data without the need of a backup. ...