3 ms·
Personally I find this to be the worst with ETL tools such as Microsoft SQL Server Integration Services (SSIS). Table-to-table mappings are often very mechanic
by jiggawatts 2y ago
Personally I find this to be the worst with ETL tools such as Microsoft SQL Server Integration Services (SSIS).
Table-to-table mappings are often very mechanical, with a set of simple exceptions or deviations, such as adding one column or skipping one column.
There is nothing fiddlier in this world than repeating these steps over and over with a GUI tool where you have to individually click each column mapping link to open its "properties" one... at... a... time... for hundreds of tables with dozens of columns each.