InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Can An Ssis Package Be Scheduled To Execute At A Defined Time Or At A Defined Interval Per Day? |
|
Answer» You can configure a SQL Server AGENT Job with a job step type of SQL Server Integration Services Package, the job INVOKES the dtexec command line utility internally to execute the package. You can RUN the job (and in TURN the SSIS package) on demand or you can create a schedule for a one time need or on a reoccurring basis. Refer to this tip to learn more about it. You can configure a SQL Server Agent Job with a job step type of SQL Server Integration Services Package, the job invokes the dtexec command line utility internally to execute the package. You can run the job (and in turn the SSIS package) on demand or you can create a schedule for a one time need or on a reoccurring basis. Refer to this tip to learn more about it. |
|