Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All


Loads a mining model or mining structure from an Analysis Services backup file onto the server.

IMPORT FROM <filename>


A string containing the name and location of the backup file to import.

If no objects are specified, the entire contents of the backup file will be loaded. If the backup file includes a database that does not exist on the server, the database will be created.

You must be a database or server administrator to export or import objects.

The following example imports the definition of the association model and its underlying structure onto the current server.

IMPORT FROM 'C:\TEMP\Association_NEW.abf'

Updated content

Corrected syntax of IMPORT statements.

Updated example to use the same extension as in the EXPORT (DMX) topic..

Removed most references to the .abf file extension, which is not required for data mining backup files.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft