Setting up and executing the Job

Procedure

Open the Basic settings view of the tFixedFlowInput component by double-clicking the component and do the following.
1. Click the […] button next to Edit schema and add two columns in the schema editor: Name, type String; Address, type String.
  
  Information noteNote: Column names are case-sensitive.
2. Click Yes when prompted.
  This propagates the schema to the tFileOutputDelimited component.
3. Select the Use Inline Content option.
4. Enter the following in the Content field.
```
Tub's Furniture Store;807 Old Trail Rd.
Toggle & Myerson Ltd;618 Sheriden rd.
Lennox Air Pollution Control;4522 N. Greenview Apt. 1B
Cotton Thumb Ltd.;1882 St. Johns
Acturial Enterprises Ltd.;1486 Oakwood;32
```
5. Leave the other options as they are.
Open the Basic settings view of the tFileOutputDelimited component by double-clicking the component and do the following.
1. Check the schema and make sure the schema has the same columns as those for the tFixedFlowInput component.
2. Enter the path to the file which you want to write the data to in the File Name field ("D:/smboutput/customers.csv" in this example).
  
  Information noteNote: If the file specified already exists, it will be overwritten. In this case, make sure the Throw an error if the file already exist option in the Advanced settings view is cleared.
3. Leave the other options as they are.
Open the Basic settings view of the tSambaConnection component by double-clicking the component and do the following.
1. Enter the IP address of the Samba host in the host field.
2. If user authentication is enabled in the Samba host, enter user name and password in the username and password fields.
3. Enter the domain name in the Domain field.
  If the Samba host is not configured with a domain, leave this field empty.
Open the Basic settings view of the tSambaPut component by double-clicking the component and do the following.
1. Select Use an existing connection and select the tSambaConnection component from the Component List drop-down list.
2. Enter the name of the shared folder set in the Samba host in the Share directory field (SmbShare in this example).
3. Enter the path to the file you want to save the uploaded file as in the Remote path field (/abc/customers.csv in this example).
4. Check the Create directory option.
  This option creates the folders specified in the Remote path field under the shared folder if the folders do not exist.
5. Enter the file path set for the tFileOutputDelimited component (that is, "D:/smboutput/customers.csv") in the Local file field.
  You can also specify the file by placing the cursor in the Local file filed, pressing Ctrl + Space, and selecting tFileOutputDelimited_1.FILE_NAME from the list that appears.
6. Leave the other options as they are.
Save the Job.
Switch to the Run view and click Run.
The file (that is, customers.csv) appears in the SmbShare/abc folder in the Samba host.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here