Use Sql Server Integration Services (Ssis) In Sql Server 2008


show more Introduction to SQL Server Integration Services (SSIS) provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training show less
please wait ...

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 s...

Introduction to SQL Server Integration Services (SSIS)
Video duration: 1m 57s 6h 54m Beginner

Viewers:

Introduction to SQL Server Integration Services (SSIS) provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...