SQL Server Integration Services (SSIS) - learning materials and web resources for beginners
Recently when I had a task to identify the learning materials (free) and web resources for SQL Server Integration Services (SSIS), then first place I have used is MVP private newsgroups. You will appreciate the immediate help I received from fellow MVPs in getting the list swiftly, they are as follows:
- Books Online (updated) - As the documentation will have much information about latest changes, such as from last hotfix or service pack.
- SQLIS website
- MSDN forums where you will get to see a good resource from the available threads/posts, rather than posting a question that might have answered there already. So it is better to have some patience in searching for required information.
- Jamie Thomson has developed a SSIS Live Search macros that will get you instant information and also this Online Beginner Resources link.
- Related articles in SQL-Server-Central website (for instance related ones):
- Brian Knight, MVP has given much insight on this SSIS-Video where you have to type SSIS to get relevant results.
I'm sure the above links should help the beginner to get a complete understanding about SSIS and DTS package migration within SQL Server.