SQL Server related thoughts

This is a collection of links to free articles that may help in studying for

Exam 70 448  -Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

I have broken this up into 6 posts based on the major areas of skills being measured taken from the Microsoft Learning page at

http://www.microsoft.com/learning/en/us/exam.aspx?id=70-448

First up is :

Implementing an SSIS Solution – which accounts for 17 % of the total skils measured

• SSIS Videos -
  • http://msdn.microsoft.com/en-us/library/dd299421%28v=SQL.100%29.aspx
• Implement control flow.
  This objective may include but is not limited to: 
  • Checkpoints;
    • https://community.altiusconsulting.com/blogs/altiustechblog/archive/2009/09/09/ssis-2008-package-restarting-and-checkpoints.aspx
  • Debug control flow;
    • http://msdn.microsoft.com/en-us/library/ms140274%28v=SQL.100%29.aspx
  • Transactions;
    • http://www.mssqltips.com/tip.asp?tip=1585
  • implement the appropriate control flow task to solve a problem;
    • http://msdn.microsoft.com/en-us/library/ms141664%28v=SQL.100%29.aspx
  • Data profiling and quality ;
    • http://www.simple-talk.com/sql/ssis/sql-server-2008–ssis-data-profiling-task/
• Implement data flow.
  This objective may include but is not limited to: 
  • Debug data flow;
    • http://msdn.microsoft.com/en-us/library/ms137944%28v=SQL.100%29.aspx
  • Implement the appropriate data flow components
    • http://msdn.microsoft.com/en-us/library/ms140080%28v=SQL.100%29.aspx
• Implement dynamic package behavior by using property expressions;
  • http://www.simple-talk.com/sql/ssis/working-with-property-expressions-in-sql-server-integration-services/ http://msdn.microsoft.com/en-us/library/ms141214%28v=SQL.100%29.aspx
• Implement package logic by using variables;
  • http://msdn.microsoft.com/en-us/library/ms141085%28v=SQL.100%29.aspx

• This objective may include but is not limited to:
  • system variables;
  • user variables;
  • variable scope
    • http://msdn.microsoft.com/en-us/library/ms141085%28v=SQL.100%29.aspx
• Implement package configurations.
  • http://msdn.microsoft.com/en-us/library/cc895212.aspx
• Implement auditing, logging, and event handling.
  This objective may include but is not limited to: 
  • use system variables for auditing;
  • use event handlers; propagate events;
  • use log providers;
  • data profiling
    • http://msdn.microsoft.com/en-us/library/ms140223%28v=SQL.100%29.aspx
    • http://msdn.microsoft.com/en-us/library/aa337088%28v=SQL.100%29.aspx
• Extend SSIS packages by using .NET code;
  • http://toddmcdermid.blogspot.com/2009/07/using-dtsmappingsurfacecontrol-in-your.html
• This objective may include but is not limited to;
  • Use the script task;
    • http://www.developer.com/net/net/article.php/3572761/Extend-the-SSIS-Script-Task-with-Your-Own-NET-Class-Library.htm
  • Use the script component;
    • http://msdn.microsoft.com/en-us/library/ms136033%28v=SQL.100%29.aspx http://blogs.msdn.com/b/michen/archive/2007/04/22/com-references-within-an-ssis-script-component.aspx
  • Use custom assemblies;
    • http://stackoverflow.com/questions/2065673/reference-a-net-3-5-assembly-in-a-script-task-in-ssis-2005