Is it better to use XMLA or SSIS to load/import CSV data into a database? My sys admin recommends using XMLA + DDL to load the data instead of traditional SSIS.
To me it sounds like SSIS is the preferred way.
Any suggestions will help greatly.
XMLA has nothing to do with loading a CSV file. If you just need to load CSV data into a relational database, use SSIS. If you need to consume multidimensional data, or change the schema of an Analysis Services database, use XMLA.