looking for a simple but complete sample for SSIS or a tutorial

Question

Hi

I'm looking for a complete sample or tutorial (requirements, conditions, how to work...)to start working with SSIS.

Indeed, I've installed SQL server 2008 developer edition recently.

Thanks for any help

Answer 1

Try the resources at http://technet.microsoft.com/en-us/sqlserver/cc510302.aspx. In particular, Tutorial: Creating a Simple ETL Package or the video Creating a Basic Package.

Answer 2

Buy and read http://www.amazon.com/Microsoft-Data-Warehouse-Toolkit-Microsoft-Business-Intelligence/dp/0471267155/ref=sr_1_1?ie=UTF8&s=books&qid=1261469207&sr=8-1. It's for SQL Server 2005, but it's still an excellent overview and guide.

Answer 3

Here is a link to a bunch of SSIS videos that covers a wide range of topics: sql share

Answer 4

Codeplex has samples, and msdn has tutorials. This should get you started.