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. ...