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.
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!