Importing SAS Package Metadata

Problem

You want to import metadata into SAS Data Integration Studio that was exported in SAS Package format.

Solution

Use the Import to SAS Package wizard to import the SAS package file that contains the metadata. The package can be saved to the same metadata server or to a different metadata server. The source and target server can be located on the same host machine or on different host machines. It is assumed that you have prepared for this task described in Preparing to Import or Export SAS Package Metadata.

Tasks

Identify the Metadata That Should Be Imported (optional)

It is easier to import metadata if you have a document that describes the metadata that was exported, the metadata that should be imported, and the main metadata associations that must be reestablished in the target environment.
For example, suppose that a SAS Data Integration Studio job was exported. When you import the job, the Import from SAS Package wizard prompts you to associate tables in the job with libraries in the target environment. If appropriate libraries do not exist, you might have to cancel the wizard, register appropriate libraries, and run the wizard again. However, if the library requirements are known and addressed ahead of time, you can simply import the tables and specify an appropriate library in the target environment.

Import the SAS Package File

Perform the following steps to import metadata using a SAS package:
  1. In the Folders tree, right-click the folder into which metadata should be imported and select Import from the pop-up menu. The Import wizard is displayed. Alternatively, you can left-click a folder and select Filethen selectImportthen selectSAS Package from the menu bar.
  2. In the first page of the wizard, select the package to be imported. Select the option to import all objects in the package or just the new objects (objects that are not registered on the target metadata server). When finished, click Next to access the Select Objects to Import page.
  3. Review the list of objects that you have selected for import. Deselect the check box for any objects that you do not want to import.
  4. If desired, click an object, and then click the Options tab to view its options. For example, you can click the Options tab to specify whether you want to import content, if content was exported with the object. You can also click Properties to review its properties. When finished, click Next to access the About Metadata Connections page.
  5. Review any metadata associations to be restored. For example, if you are importing a table, you are prompted to specify a library for that table. Click Next to access the SAS Application Servers page and begin restoring the required associations.
  6. Review any application server associations. Then, click Next to access the Directory Paths page.
  7. Review any directory paths. Then, click Next to access the Summary page.
  8. Review the metadata to be imported. Then click Next to access the Importing Object page. The metadata is imported. A status page is displayed, indicating whether the import was successful. A log with a datetime stamp is saved to your user directory.
  9. If desired, click View Log to view a log of the import operation. When finished, click Finish.

Usage Notes

A Generated transformation is a custom transformation that you create with the Transformation Generator wizard.
The following rules govern the import of a Generated transformation:
  • If the name of the imported transformation is unique in the target metadata repository, or at least unique within the target folder, then use that name for the target transformation.
  • If the target transformation has the same ID as the source transformation, then the source transformation will overwrite the target transformation.
If these rules are not followed, then the import fails.
For more information about generated transformations, see Working with User-Written Code.