From the course: SQL Server 2008 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Introduction to SQL Server Integration Services (SSIS) - SQL Server Tutorial
From the course: SQL Server 2008 Essential Training
Introduction to SQL Server Integration Services (SSIS)
It'd be we nice to think that our data magically appears in our database, is updated there, is manipulated and reported on there, and never needs to go anywhere else or come from anywhere else. But that's not the case and that is where SQL Server Integration Services comes in. This is the part of SQL Server 2008 that deals with getting data into our databases or extracting it and moving it somewhere else. This can range from the very simple, where Integration Services will take care of importing a one-off collection from an old access database, to very complex indeed. Importing data from multiple sources including other databases, having flat files and XML documents, and being able to clean this information all up, in some cases of standardizing it, in other cases transforming it and performing computations on it, and then merging all this and storing the results in the database. And then perhaps most importantly, being able to take all these operations and package them all up so they…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.