Aracılığıyla paylaş

  • Makale

Toplu olarak Ekle görev Editor'ı (Seçenekler sayfa)

Use the Options page of the Bulk Insert Task Editor dialog box to set properties for the bulk insert operation.The Bulk Insert task copies large amounts of data into a Microsoft SQL Server table or view.

Toplu ekler ile çalışma hakkında bilgi için bkz: Toplu ekleme görev ve BULK INSERT (Transact-SQL).

Seçenekler

  • CodePage
    Specify the code page of the data in the data file.

  • DataFileType
    Specify the data-type value to use in the load operation.

  • BatchSize
    Specify the number of rows in a batch.The default is the entire data file.If you set BatchSize to zero, the data is loaded in a single batch.

  • LastRow
    Specify the last row to copy.

  • FirstRow
    Specify the first row from which to start copying.

  • Seçenekler

    Terim

    Tanım

    Kısıtlamalarını denetleyin.

    Select to check the table and column constraints.

    Boş değerlere tutun.

    Select to retain null values during the bulk insert operation, instead of inserting any default values for empty columns.

    Enable identity insert

    Select to insert existing values into an identity column.

    Tablo kilit

    Select to lock the table during the bulk insert.

    Yangın Tetikleyicileri

    Select to fire any insert, update, or delete triggers on the table.

  • SortedData
    Specify the ORDER BY clause in the bulk insert statement.Sağladığınız bir sütun adı geçerli bir hedef sütununda olmalıdır tablo.Varsayılan değer false. This means that the data is not sorted by an ORDER BY clause.

  • MaxErrors
    Specify the maximum number of errors that can occur before the bulk insert operation is canceled.A value of 0 indicates that an infinite number of errors are allowed.

    Not

    Each row that cannot be imported by the bulk load operation is counted as one error.