Scheduling SSIS packages as job

Scheduling SSIS package as job

SSIS package is stored in file system. So to schedule the SSIS package we need windows account to access the SSIS packages.
After creating windows account with administrative privilages, create Credential for that account.
Once Credentials are ready create proxy using the credential just created. And attached that proxy to SSIS in SQL Server Agent.
Now your SSIS package is ready to schedule as a job.

By Cos mos   Popularity  (1539 Views)