>Kevin,
>I like to know more about SSIS and how it can be used in a business application with a SQL Server backend. I always thought for more complex sql tasks stored procedures are the way to go, and the rest with regular sql statements.

Later today I'm going to post some links to some SSIS videos in the SQL Server section of the UT.

One thing - it's not a matter of SSIS vs stored procedures. There are many ETL solutions out there that use stored procedures and custom T-SQL code, and then use SSIS as a workflow manager/wrapper around the procs. So it's not an either-or.