SSIS QuickBytes

How to create a dynamic subject or message for the Send Mail task in SSIS 2k5
http://support.microsoft.com/kb/906547

How to add an incremental counter in a SSIS 2k5 package by using a Script component in a Data Flow task
http://support.microsoft.com/kb/908460/en-us

Sending an HTML Mail Message with the Script Task
http://msdn.microsoft.com/en-gb/library/ms403365.aspx

Sql Server Quick reference : How to

How to get the version of Sqlserver ?
Step 1 :
Open query analyser and execute the following
Select serverproperty('productversion'), serverproperty('productlevel'), serverproperty('edition')

Step 2 :
If Output is 10.0.1600.22 for first field then its sqlserver 2008
If Output is 9.00.3257.00 for first field then its sqlserver 2005

For further details : http://support.microsoft.com/kb/321185

---

Common Solution for T-sql problems
'http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=SelectTopNbyGroup&referringTitle=Home

Recursive Queries Using Common Table Expressions

http://msdn.microsoft.com/en-us/library/ms186243.aspx

.net Quick reference

Common Colors reference chart