Export (0) Print
Expand All

Enabling and Configuring Package Configurations

Updated: 12 December 2006

In this task, you will enable package configurations using the Package Configuration Wizard. You will use this wizard to generate an XML configuration file that contains configuration settings for the Directory property of the Foreach Loop container. The value of the Directory property is supplied by a new package-level variable that you can update at run time. Additionally, you will populate a new sample data folder to use during testing.

ms166598.note(en-US,SQL.90).gifNote:
The Package Configuration Wizard does not save the Password and UserName property values in the XML configuration file. If you use the dtexec command prompt utility to run a package, you must use a text editor, such as Notepad, to add the property values to the file. Otherwise, the package will not run. For more information about how to use the command prompt utility, see How to: Run a Package Using the DTExec Utility.

  1. Click the background of the Control Flow tab in SSIS Designer. This sets the scope for the variable you will create to the package.

  2. On the SSIS menu, select Variables.

  3. In the Variables window, click the Add Variable icon.

  4. In the Name box, type varFolderName.

    ms166598.note(en-US,SQL.90).gifImportant:
    Variable names are case sensitive.

  5. Verify that the Scope box shows the name of the package, Lesson 3.

  6. Set the value of the Data Type box of the varFolderName variable to String.

  7. Return to the Control Flow tab and double-click the Foreach File in Folder container.

  8. On the Collection page of the Foreach Loop Editor, click Expressions, and then click the ellipsis button (…).

  9. In the Property Expressions Editor, click in the Property list, and select Directory.

  10. In the Expression box, click the ellipsis button (…).

  11. In the Expression Builder, expand the Variables folder, and drag the variable User::varFolderName to the Expression box.

  12. Click OK to exit the Expression Builder.

  13. Click OK to exit the Property Expressions Editor.

  1. Click the background of the Control Flow tab in SSIS Designer.

  2. On the SSIS menu, click Package Configurations.

  3. In the Package Configurations Organizer dialog box, select Enable Package Configurations, and then click Add.

  4. On the welcome page of the Package Configuration Wizard, click Next.

  5. On the Select Configuration Type page, verify that the Configuration type is set to XML configuration file.

  6. On the Select Configuration Type page, click Browse.

  7. By default, the Select Configuration File Location dialog box will open to the project folder.

  8. In the Select Configuration File Location dialog box, for File name type SSISTutorial, and then click Save.

  9. On the Select Configuration Type page, click Next.

  10. On the Select Properties to Export page, in the Objects pane, expand Variables, expand varFolderName, expand Properties, and then select Value.

  11. On the Select Properties to Export page, click Next.

  12. On the Completing the Wizard page, type a configuration name for the configuration, such as SSIS Tutorial Directory configuration. This is the configuration name that is displayed in the Package Configuration Organizer dialog box.

  13. Click Finish.

  14. Click Close.

  15. The wizard creates a configuration file, named SSISTutorial.dtsConfig, that contains configuration settings for the value of the variable that in turn sets the Directory property of the enumerator.

    ms166598.note(en-US,SQL.90).gifNote:
    A configuration file typically contains complex information about the package properties, but for this tutorial the only information should be [User::varFolderName].Properties[Value].

  1. In Windows Explorer, at the root level of your drive (for example, C:\), create a new folder named New Sample Data.

  2. Open the c:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Creating a Simple ETL Package\Sample Data folder and then copy any three of the sample files from the folder.

  3. In the New Sample Data folder, paste the copied files.

Release History

12 December 2006

New content:
  • Added a note about the property values that the Package Configuration Wizard does not save in the XML configuration file, and how to add these properties to the configuration file before you use the dtexec command prompt utility to run a package.

Community Additions

ADD
Show:
© 2014 Microsoft