Skip to main content Skip to complementary content

Setting up the Job

Procedure

  1. Drop the following components from the Palette onto the design workspace: tMSSqlConnection, tFileInputDelimited, tMSSqlOutput, tMSSqlInput, tLogRow, and tMSSqlCommit.
  2. Connect tMSSqlConnection to tFileInputDelimited using a Trigger > OnSubjobOk link.
  3. Do the same to connect tFileInputDelimited to tMSSqlInput and tMSSqlInput to tMSSqlCommit.
  4. Connect tFileInputDelimited to tMSSqlOutput using a Row > Main link.
  5. Do the same to connect tMSSqlInput to tLogRow.

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 – please let us know!

Leave your feedback here