Aracılığıyla paylaş

  • Makale

Veri Düzenleyicisi (Genel sayfası)'in görev profil oluşturma

Use the General page of the Data Profiling Task Editor to configure the following options:

  • Specify the destination for the profile output.

  • Use the default settings to simplify the task of profiling a single table or view.

For more information about how to use the Data Profiling task, see Görev için profil oluşturma verileri ayarlama.For more information about how to use the Data Profile Viewer to analyze the output of the Data Profiling task, see Profil çıkış veri profil Görüntüleyicisi'nde görüntüleme.

To open the General page of the Data Profiling Task Editor

  1. In Business Intelligence Development Studio, open the Integration Services package that has the Data Profiling task.

  2. On the Control Flow tab, double-click the Data Profiling task.

  3. In the Data Profiling Task Editor, click General.

Data Profiling Options

  • Timeout
    Specify the number of seconds after which the Data Profiling task should timeout and stop running.The default value is 0, which indicates no timeout.

Destination Options

Important noteImportant Note:

The output file might contain sensitive data about your database and the data that database contains.For suggestions about how to make this file more secure, see Paketleri tarafından kullanılan dosyalara erişimi denetleme.

  • DestinationType
    Specify whether to save the data profile output to a file or a variable:

    Değer

    Açıklama

    FileConnection

    Save the profile output to a file in the location that is specified in a File connection manager.

    NoteNote:
    You specify which File connection manager to use in the Destination option.

    Variable

    Save the profile output to a package variable.

    NoteNote:
    You specify which package variable to use in the Destination option.

  • Hedef
    Specify which File connection manager or package variable contains the data profile output:

    • If the DestinationType option is set to FileConnection, the Destination option displays the available File connection managers.Select one of these connection managers, or select <New File connection> to create a new File connection manager.

    • If the DestinationType option is set to Variable, the Destination option displays the available package variables in the Destination list.Select one of these variables, or select <New Variable> to create a new variable.

  • OverwriteDestination
    Specify whether to overwrite the output file if it already exists.The default value is False.The value of this property is used only when the DestinationType option is set to FileConnection.When the DestinationType option is set to Variable, the task always overwrites the previous value of the variable.

    Important noteImportant Note:

    If you try to run the Data Profiling task more than once without changing the output file name or changing the value of the OverwriteDestination property to True, the task fails with the message that the output file already exists.

Other Options