SSIS sites

Here are some good websites all about SSIS the ETL (Extract Transform Load) database tool from Microsoft.

Best Practices:

http://consultingblogs.emc.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx

Good guide on SSIS development:

http://consultingblogs.emc.com/jamiethomson/archive/2007/03/11/SSIS_3A00_-Package-Template.aspx

FYI:-how to create indirect config - for configuring the location of 'RootFolder' and for connection strings etc.

http://ssis.trigonblue.com/IndirectConfigurations/tabid/526/Default.aspx

How to load from a 'flattened' view to a normalised view,

using raw files:

http://consultingblogs.emc.com/jamiethomson/archive/2006/05/22/3974.aspx

-you could also refer to the TransferStudentsPackage

SQL Server DatabaseMail & Alerts:

http://www.mssqltips.com/tip.asp?tip=1523