Friday 12 August 2016

How to call an SSIS package from the command line

 Alternatively save the script below as a batch file

echo "Starting Windows Task Scheduler - Batch File"
dtexec.exe /DTS "\"\MSDB\Load_FBDFiles_v01_13072016\"" /SERVER "\".\"" /CHECKPOINTING OFF  /REPORTING V
echo "Completing Windows Task Scheduler - Batch File"


The batch file can be called from an automated windows task



Here’s how to get there:


  •       Open the Control Panel.
  •        Open the Administrative Tools window.
  •        In Windows 7, look under System and Security(Windows Vista, under System and Maintenance)
  •        Open the Task Scheduler icon.
  •        If prompted, type the administrator’s password or click Continue.
  •        The Task Scheduler window appears.
  •        Create new Task & Schedule ‘Load FBD Files Monthly’ accordingly, point task towards the following script “Load_FDB_Batch_WinTScheduler.bat” Ensure the task is set to run with the highest privileges. Set the schedule to desired frequency. The task should also be set to “Run whether user is logged in or not” and “Do not store password” should be checked.

No comments:

Post a Comment