SQL52SIS SQL Server Integration Services 2005, Quanta Training Ltd

Prices shown are excluding VAT. If you are booking any course with an exam and you are using a prepaid account (training days) or passports, you will be invoiced for the exams separately to ensure that you pay only the required amount.

SQL Server Integration Services 2005

SQL52SIS 2 Days	COURSE TOPICS A Guided Tour of SSIS Understanding SSIS Exploring and Executing an SSIS Package in BIDS Exploring and Executing a Package Outside of BIDS Introduction to Control Flow Overview of Control Flow in SSIS Control Flow Tasks Workflow Tasks Other SQL Server Operations Tasks Precedence Constraints Data Processing Tasks Introduction to Data Flows Data Flow Overview Data Flow Pipeline Data Flow Sources Data Flow Destination Data Viewers Data Transformations Variables and Configurations Understanding Variables Using variables in control flow Using variables in data flow Understanding Property expressions Using Property expressions Understanding Configurations Using Configurations Using variables and Configurations between packages	Error Logging and Handling Error Logging and Handling Overview Checkpoints Package Logging Event Handling Package Deployment Overview of Deploying Packages Deployment Challenges Create a Package deployment utility The Package Installation Wizard Deploy a Package to the File System Deploy a Package to SQL Server Redeploying Updated Packages Package Management Overview of Package Management Managing packages with DTUtil Managing packages with SQL Server Management Studio Executing packages Scheduling packages with SQL Server Agent SSIS Security Course Outline v1.0
THE COURSE The course will enable delegates to design and use Integration Services packages. Packages will be designed using Business Intelligence Development. The course includes connections, control flows, data flows, variables, logging and error handling. The course is aimed at people who are new to Integration Services. Exercises are included to consolidate the skills taught. WHO SHOULD ATTEND IT professionals who need to build and use Integration Services packages for Microsoft SQL Server 2005. PRE-REQUISITES No previous knowledge of Microsoft SQL Server Integration Services 2005 is required. A basic knowledge of database principles, Microsoft Windows and Microsoft SQL Server is required. This could be gained from our SQL Server Essentials course or through work experience.