CODEWITHSUNDEEP
sqlssisddlxmla
Arcadian
Arcadian

Reputation: 4350

SQL Integration Services: XMLA or SSIS to Load CSV

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.

Upvotes: 0

Views: 197

Answers (1)

Santiago Cepas
Santiago Cepas

Reputation: 4094

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.

Upvotes: 1

Related Questions