SQL Server 2005 ETL process - made simple and easy to learn with SSIS tutorials
Still most of the users in SQL Server 2005 are afraid of using SSIS - SQL Server Integration Services for their ETL process and procedures.
I would say the newbie users are in luck to obtain help easily on the web by referring to the blogs and forums/newsgroups in this cyber age. In this regard Microsoft Documentation team has given such help by updating Books Online and Tutorials as and when it is require, for this you can go through the tutorials listed below:-
http://msdn2.microsoft.com/en-us/library/ms365338.aspx
http://msdn2.microsoft.com/en-us/library/ms365191.aspx
http://msdn2.microsoft.com/en-us/library/ms169917.aspx &
http://msdn2.microsoft.com/en-us/library/ms167031.aspx
I recommend to go through the above links and try out on your SQL Server 2005 Development platform to get more out on your ETL procedures.
Good luck.