After install SQL Server 2005/2008 with the Analisys Services, Reporting Services and Integration Services packages, you can create some BI related projects on your Visual Studio. We create a SSIS project and we have a tour inside of the toolbox, features, and the best tool, the designer.
If you are in this step, I strongly recommend to follow a some basic guide, because SSIS seems a really good tools that it can help us.
Recommend site: http://msdn.microsoft.com/en-us/library/ms141026.aspx
