tag:blogger.com,1999:blog-34364481714765152082009-06-20T22:30:21.785-04:00Waynehttp://www.blogger.com/profile/14749286509523811134noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3436448171476515208.post-22824201452422516802008-12-26T10:26:00.001-05:002008-12-26T10:27:39.846-05:00Consider Donating to the Wikipedia foundation.<br /><br /><br /><a href="http://wikimediafoundation.org/wiki/Donate/en"><img border="0" alt="Wikipedia Affiliate Button" src="http://upload.wikimedia.org/wikipedia/foundation/1/1a/2008_fundraiser_banner_button-en.png" /></a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3436448171476515208-2282420145242251680?l=warthurton.arthurton.com'/></div>Waynehttp://www.blogger.com/profile/14749286509523811134noreply@blogger.com0tag:blogger.com,1999:blog-3436448171476515208.post-14804214087256727432008-05-14T14:17:00.001-04:002008-05-14T19:13:22.862-04:00<p><a href="http://www.amazon.com/gp/redirect.html?ie=UTF8&amp;location=http%3A%2F%2Fwww.amazon.com%2Fgp%2Fproduct%2FB0006PUDQK&amp;tag=arthurtoncom-20&amp;linkCode=ur2&amp;camp=1789&amp;creative=9325"><img style="margin: 0px 15px 0px 0px" src="http://ecx.images-amazon.com/images/I/21ywYV-UvZL._SL500_AA182_.jpg" align="left" /></a>&#160;&#160; </p> <p>&#160;</p> <p>I have just purchased this <a href="http://www.amazon.com/gp/redirect.html?ie=UTF8&amp;location=http%3A%2F%2Fwww.amazon.com%2Fgp%2Fproduct%2FB0006PUDQK&amp;tag=arthurtoncom-20&amp;linkCode=ur2&amp;camp=1789&amp;creative=9325">Smart Strip</a><img style="margin: 0px; border-top-style: none! important; border-right-style: none! important; border-left-style: none! important; border-bottom-style: none! important" height="1" alt="" src="http://www.assoc-amazon.com/e/ir?t=arthurtoncom-20&amp;l=ur2&amp;o=1" width="1" border="0" />.&#160; It automatically switches 6 outlets base on power coming in to a control outlet.&#160; Additionally it has 3 always on outlets.&#160; This will solve my problem of not having a remote power switch for my original XBOX running <a href="http://xbmc.org/">XBMC</a>.&#160; Additionally I can help avoid all the <a href="http://en.wikipedia.org/wiki/Phantom_load">phantom load</a> that shows up from my AV equipment.</p> <div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3436448171476515208-1480421408725672743?l=warthurton.arthurton.com'/></div>Waynehttp://www.blogger.com/profile/14749286509523811134noreply@blogger.com0tag:blogger.com,1999:blog-3436448171476515208.post-58668041047275011412008-04-24T16:33:00.001-04:002008-04-24T16:36:07.218-04:00<ul> <p>In SSIS I have a Data Flow that looks like the following:</p> <p><a href="http://lh5.ggpht.com/warthurton/SBDuooueBvI/AAAAAAAAAIA/xQYBi9d2i58/clip_image001%5B3%5D.png?imgmax=800"><img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="244" alt="clip_image001" src="http://lh6.ggpht.com/warthurton/SBDuo4ueBwI/AAAAAAAAAII/jESBRFrZFz8/clip_image001_thumb.png?imgmax=800" width="165" border="0" /></a></p> <p>To change the numeric data type precision I did the following.</p> <ol> <li>Ensure the destination (DST_OLEDB Extract did_ms_contracts_v) has the desired precision</li> <li>Change the properties on the data source to <strong>ValidateExternalMetadata</strong> = False<a href="http://lh3.ggpht.com/warthurton/SBDupIueBxI/AAAAAAAAAIQ/I39CMeMlnK0/clip_image002%5B3%5D.png?imgmax=800"><img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="215" alt="clip_image002" src="http://lh4.ggpht.com/warthurton/SBDupYueByI/AAAAAAAAAIY/QfkXgKQ7YbM/clip_image002_thumb.png?imgmax=800" width="244" border="0" /></a></li> <li>Open Advanced Editor on the data source</li> <li>Change the precision of the desired columns in OLE DB Source Output &#8211; External and Output columns&#160; (Might be able to get away with Output only, but I have not tested that)<a href="http://lh5.ggpht.com/warthurton/SBDupoueBzI/AAAAAAAAAIg/Bg0cFcy0IMQ/clip_image003%5B3%5D.png?imgmax=800"><img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="78" alt="clip_image003" src="http://lh6.ggpht.com/warthurton/SBDup4ueB0I/AAAAAAAAAIo/_CDh3dyjBdA/clip_image003_thumb.png?imgmax=800" width="244" border="0" /></a></li> <li>Close the editor</li> <li>Reopen the Advance Editor on the data source</li> <li>Choose Yes to fix errors</li> <li>Check the Error Output for proper precision on Columns</li> <li>Close the window</li> <li>Verify metadata on Data Flow path as it travels towards the data destination</li> </ol> <p>This seems to be the magic formula.</p> </ul> <div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3436448171476515208-5866804104727501141?l=warthurton.arthurton.com'/></div>Waynehttp://www.blogger.com/profile/14749286509523811134noreply@blogger.com0