I would say it may be easier to transform data into a canonical data model from outside the SQL sphere. Parsing flat files or XML files in SQL was common in the past. Today, there are tools with capabilities beyond SQL that can extract data and populate data sets. A clear separation between the responsibilities of data ingestion and data makes the architecture more robust. SSIS for instance can easily become messy because things end up being coupled in unintentional ways.