Do you use Wikipedia every day?

Consider Donating to the Wikipedia foundation.

Smart Strip

  

 

I have just purchased this Smart Strip.  It automatically switches 6 outlets base on power coming in to a control outlet.  Additionally it has 3 always on outlets.  This will solve my problem of not having a remote power switch for my original XBOX running XBMC.  Additionally I can help avoid all the phantom load that shows up from my AV equipment.

Fixing Precision on Oracle Number Columns in SSIS

In SSIS I have a Data Flow that looks like the following:



To change the numeric data type precision I did the following.

1. Ensure the destination (DST_OLEDB Extract did_ms_contracts_v) has the desired precision
2. Change the properties on the data source to ValidateExternalMetadata = False
3. Open Advanced Editor on the data source
4. Change the precision of the desired columns in OLE DB Source Output – External and Output columns  (Might be able to get away with Output only, but I have not tested that)
5. Close the editor
6. Reopen the Advance Editor on the data source
7. Choose Yes to fix errors
8. Check the Error Output for proper precision on Columns
9. Close the window
10. Verify metadata on Data Flow path as it travels towards the data destination

This seems to be the magic formula.