Updated: March 2, 2016

Loads a mining model or mining structure from an Analysis Services Backup File (.abf) file onto the server.

IMPORT FROM <filename>  

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

If no objects are specified, the entire contents of the .dmb file will be loaded. If the .dmb 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 entire contents of the file containing the association model and structure onto the current server.

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

Data Mining Extensions (DMX) Data Definition Statements
Data Mining Extensions (DMX) Data Manipulation Statements
Data Mining Extensions (DMX) Statement Reference
Export and Import Data Mining Objects

Community Additions