How to Schedule an SSIS Package as a Job - view details
We will take a look at how to schedule an SSIS (SQL Server Integration Services) package as a a job step, a fairly simple process if you understand proxy accounts and job steps. It is recommended that you watch "Understanding Proxy Accounts and Job Steps" before viewing this video.
Highlights from this video:How to load a table with Integration Services
Making a file connection from SSIS to SQL to load your data
Using an SSIS package as a job step type
Run a job step as a proxy
and much more Source: http://www.learnitfirst.com/Course/157/Video/1887/Schedule-an-SSIS-Package-as-Job.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 200 (Beginner - Intermediate) Length: 10:15 (17.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: ssis, package,job,job step,schedule,sql server,2008
This video comes from the SQL Server 2008 DBA online training course, SQL Server 2008 Database Administration. And be sure to check out even more MSSQL Server 2008 training videos.
