Reading the input data

MSSql

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Real-Time Big Data Platform
Talend Data Management Platform
Talend Open Studio for MDM
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Data Integration
Talend Open Studio for Big Data
Talend ESB
Talend Big Data
Talend Data Fabric
Talend Big Data Platform
Talend MDM Platform
Talend Data Services Platform
task
Design and Development > Third-party systems > Database components > MSSql components
Data Quality and Preparation > Third-party systems > Database components > MSSql components
Data Governance > Third-party systems > Database components > MSSql components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click the tFileInputDelimited component to open its Component view.
  2. Click the [...] button next to the File Name/Stream field to browse to the input file. In this example, it is D:/Input/Employee_Wage.txt. This text file holds three columns: id, name and wage. id;name;wage 51;Harry;2300 40;Ronald;3796 17;Theodore;2174 21;James;1986 2;George;2591 89;Calvin;2362 84;Ulysses;3383 4;Lyndon;2264 17;Franklin;1780 86;Lyndon;3999
  3. In the Header field, type in 1 to skip the first row of the input file.
  4. Click Edit schema to define the data to pass on to the tMSSqlOutput component. In this example, we define id as the key, and specify the length and precision for each column respectively.
    Click OK to close the schema editor. A dialog box opens, and you can choose to propagate the schema to the next component.
    Related topic: tFileInputDelimited.