Setting up the Job
Procedure
- Drop the following components from the Palette onto the design workspace: tMSSqlConnection, tFileInputDelimited, tMSSqlOutput, tMSSqlInput, tLogRow, and tMSSqlCommit.
 - Connect tMSSqlConnection to tFileInputDelimited using a Trigger > OnSubjobOk link.
 - Do the same to connect tFileInputDelimited to tMSSqlInput and tMSSqlInput to tMSSqlCommit.
 - Connect tFileInputDelimited to tMSSqlOutput using a Row > Main link.
 - Do the same to connect tMSSqlInput to tLogRow.