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


IMPORT [<object type> <object name>[, <object name>] [<object type> <object name>[, <object name] ] ] FROM <filename>


  • object type
    Optional. The type of the object to import (either mining model or mining structure).
  • object name
    Optional. The name of the object to import.
  • filename
    The name and location of the .cub file to import as a string.


If no objects are specified, the entire contents of the .abf file will be loaded. If the .abf 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.

Import Complete File Example

The following example imports the entire contents of the TM Cluster file onto the server.

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

See Also


Data Mining Extensions (DMX) Data Definition Statements
Data Mining Extensions (DMX) Data Manipulation Statements
Data Mining Extensions (DMX) Statement Reference

Help and Information

Getting SQL Server 2005 Assistance