Import File (General Page)

Use this page to upload items from the file system to a report server database. Uploaded files are represented as items in Object Explorer. Uploaded report definition (.rdl) files are published to a report server as reports. Uploaded model definition (.smdl) files are published as models. All other file types are stored as resources. Examples of resources that you may want to upload include image files, documents, or previously exported reports you have saved in file formats.

When uploading model definition files, be sure to do the following:

  • Verify that the published model includes data source view information. It is possible to have a valid .smdl file that does not include data source view information. If the data source view information is missing, the model cannot retrieve data for a Report Builder report. To verify that the published model contains data source view information, use Report Manager to inspect the contents of the file. Click Edit on the General properties page of the model to view file contents. You cannot use Management Studio to view the contents of a published model. For more information, see How to: Edit or View the Source File of a Published Model or Report Definition (Report Manager).
  • Select a shared data source for the model. Report models use shared data sources to get a connection string and data processing extension information. Because the model definition files that you upload will be published without the shared data source, you must specify which shared data source to use. If no shared data source exists with the values that you want to use, you must create one. For more information, see How to: Create, Delete, or Modify a Shared Data Source (Management Studio).

The folder from which you initiate the upload operation is the folder that will contain the uploaded file. After the upload is complete, you can move the item to a different location.

Options

  • Name
    Specifies the name of the item, as it appears in Object Explorer and other viewing applications. The item name can be different from the file name. A name must contain at least one alphanumeric character. It can also include spaces and some symbols. Do not use the following characters when specifying a name:

    ; ? : @ & = + , $ / * < > | " /

  • File to Upload
    Specifies the file system path to the file you want to upload. Click the browse button (...) to navigate to the file.
  • Overwrite item if it exists
    Enable Overwrite item if it exists if you want to replace an existing report server item with a newer version that you import from the file system.
  • File Size
    Specifies the storage requirements in kilobytes that this item will use in the report server database.
  • MIME Type
    Specifies the Multipurpose Internet Mail Extensions (MIME) type of the file.

See Also

Reference

Object Explorer Reporting Services F1 Help

Other Resources

Reporting Services F1 Help
Uploading Files to a Folder
Managing Resources

Help and Information

Getting SQL Server 2005 Assistance