Date in yyyy-mm-dd format in SSIS

You might face few issues in SSIS package date format as few functions like convert wont work in this enviornment instead you have to use DT_STR,DT_WSTR, check this link for your date format requirements.

Here's one more to crowdsourcing.....Fixya Raises $6 Million B Round for Crowdsourced Tech-Support

Companies hate providing good tech support for their products because it is expensive. And consumers hate calling up tech support when they can’t get a gadget to work properly because they usually get the run-around. The idea for Fixya is quite simple: Let consumers help fix each other’s gadgets.

MSDN SQL 2005 Setup Failure - Fixes

Fixes to couple of issues i faced while re-installing SQL 2005 on my dev box

If you get 'the system administrator has set policies to prevent this installation' issue then

1. Open regedit.exe
2. Find the registry path 'HKEY_CLASSES_ROOT\Installer\Products\'
3. Delete all the subkeys that are empty
4. Run msxml6.msi again

If you get 'higher version of MSXML6' issue then

1. Open regedit.exe
2. Find a folder similar to Hkey_local_machine\software\classes\installer\products\ check the keys inside it to confirm it is the MSXML6 parser key
3. Delete this key
4. Run msxml6.msi again