tELTMSSqlOutput
Executes the SQL Insert, Update and Delete statement to the MSSql
database
The three ELT MSSql components are closely related, in
terms of their operating conditions. These components should be used to handle MSSql DB
schemas to generate Insert statements, including clauses, which are to be executed in
the DB output table defined.
Carries out the action on the table specified and inserts the data
according to the output schema defined the ELT Mapper.
tELTMSSqlOutput Standard properties
These properties are used to configure tELTMSSqlOutput running in the Standard Job
framework.
The Standard
tELTMSSqlOutput component belongs to the ELT family.
The component in this framework is available in all Talend
products.
Basic settings
Action on data |
On the data of the table defined, you can
Insert: Adds new entries
Update: Updates entries
Delete: Deletes the |
Schema and Edit schema |
A schema is a row description. It defines the number of fields Click Edit
|
 |
Built-in: The schema is |
 |
Repository: The schema |
Where clauses for (for UPDATE and |
Enter a clause to filter the data to be updated |
Default Table Name |
Enter the default table name, between double |
Default Schema Name |
Enter the default schema name,between double |
Table name from connection name is |
Select this check box when the name of the connection to this |
Use different table name |
Select this check box to define a different |
Mapping |
Specify the metadata mapping file |
Advanced settings
Use update statement without subqueries |
Select this option to generate an UPDATE statement for the This option is available when Update is selected from the |
tStatCatcher Statistics |
Select this check box to gather the Job |
Global Variables
Global Variables |
NB_LINE: the number of rows read by an input component or
NB_LINE_INSERTED: the number of rows inserted. This is an
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
tELTMSSqlOutput is to be Note:
Note that the ELT components do not handle |
Limitation |
Due to license incompatibility, one or more JARs required to use |