• PRODUCTS
  • SUPPORT
  • DOCS
  • PARTNERS
  • COMPANY
  • QUOTE
  • ACCOUNT
  • STORE
QUOTE

Documentation

Support Forums
What can we help you with?
Topics

Adf Dataflow Error Handling Sink Settings Element

API Type:
Varigence.Languages.Biml.DataFactory.AstAdfDataflowErrorHandlingSinkSettingsNode
X-Ref:
  • Ast Adf Dataflow Error Handling Sink Settings Node
  • Ast Adf Dataflow Sql Script Sink Settings Node
  • Ast Adf Dataflow Database Sink Settings Base Node
  • Ast Adf Dataflow Sink Settings Base Node

Attributes

AttributeAPI TypeDefaultDescription
AllowDeleteString 
Allow rows to be deleted in the sink.
AllowInsertString 
Allow rows to be inserted in the sink.
AllowUpdateString 
Allow rows to be updated in the sink.
AllowUpsertString 
Allow rows to be upserted in the sink.
BatchSizeString"-1"
Size of batches for columnar caching.
ErrorHandlingLinkedServiceNameAstAdfAzureStorageLinkedServiceBaseNode 
Specifies a reference to the linked service that will store the log of errors. This references an existing definiton.
ErrorRowHandlingAdfErrorRowHandlingStopOnFirstError
Specifies whether to continue on error (StopOnFirstError vs AllErrors).
OutputRejectedDataString 
Specifies if rejected data should be logged in an error handling Linked Service.
RejectedContainerString 
Specifies the name of the rejected container in the error handling linked service's file structure.
RejectedFolderString 
Specifies the folderpath for the rejected file in the error handling linked service's file structure.
ReportSuccessOnErrorString 
Setting this to true marks the dataflow as a successful run, even if rows were rejected or errors were found.
TableActionAdfDataflowSinkTableActionNone
Select the table action: None, Truncate, Recreate.
TransactionCommitAdfErrorHandlingTransactionCommitSingle
Commit each record or do it by batch.

Collection Children

ChildAPI TypeDescription
<Annotations>
    <Annotation />
</Annotations>
AstAnnotationNode
This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code.
<KeyColumns>
    Multiple Choices...
</KeyColumns>
AstAdfDataflowKeyColumnBaseNode
Choose which column(s) is used to determine if a row from the source matches a row from the sink.
<PostSqlScripts>
    <Script />
</PostSqlScripts>
String
This is a collection of scripts to run after the sink action.
<PreSqlScripts>
    <Script />
</PreSqlScripts>
String
This is a collection of scripts to run before the sink action.

© Varigence