Analytics in Action

Scheduling SSIS packages to run using SQL Server Agent Service

SQL Server Agent Service enables you to schedule administration tasks. This can include tasks such as backing up a database or executing SQL Server Integration Services (SSIS) packages. This video demonstrates how to schedule a SSIS package to run at a predefined time. This is useful for executing packages at times when server loads are particular light, or out of normal working hours.

admin

2 Responses to “Scheduling SSIS packages to run using SQL Server Agent Service”

  1. Hieu

    I have some SSIS packages debuged sucessfuly. I follow your video and Scheduling SSIS packages to run using SQL Server Agent Service. But it is not sucessful. It have Message “Executed as user: NT Service\SQLAgent$SQLEXPRESS. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 10:21:58 PM DTExec: The package execution returned DTSER_SUCCESS (0) but had warnings, with warnings being treated as errors. Started: 10:21:58 PM Finished: 10:22:22 PM Elapsed: 23.962 seconds. The command line parameters are invalid. The step failed.”
    Can you help solve it.