Geeks With Blogs
Scott Lock Thoughts on .Net, and Windows Phone October 2008 Entries
Converting Day of Year and Year to Date in SSIS
I ran accross a field in a flat file yesterday that was in the format of "CCYYDDD". Now I can only assume that "CC" means century, but that's not the point. The actual value was "2008294". I needed to write an expression that converted the year and day of year format to a standard date. Here's the expression to do this (thank you to Ed Buhain for brainstorming): DATEADD("d", ((DT_I4)SUBSTRING(Date, 5, 3) - 1), (DT_DATE)("1/1/" + SUBSTRING(Date, 1, 4))) Where "Date" is the value you need to convert. ......

Posted On Friday, October 31, 2008 9:48 AM

Using Personal Contacts in the Outlook Address Folders
If in the past you have had the problem where the contacts in your personal outlook contact folder do not appear in the list of address folders when you click the "To..." button when sending an email, here is a solution. (Thanks to Burton White of Excella Consulting) Tools -> Email Accounts Select "Add a new directory or address book" Select "Additional address books" Select "Outlook Address book" When you do a search for an address by clicking "To..." in an email, it defaults to show your addresses ......

Posted On Thursday, October 30, 2008 1:09 PM

SharePoint Upgrade - Completed - Final Thoughts
After many long hours working on upgrading our clients intranet from SPS 2003 to MOSS, we completed the rollout over a very long weekend. Ed Buhain, the client and I spent a fair bit of time babysitting the process, tackling last minute gotchas as they came up. One of the final issues we had was after all of the time testing, debugging, prepping, etc we had not run through the upgrade process with the infrastructure update applied. I was fully prepared to do my workarounds in order to get all the ......

Posted On Monday, October 20, 2008 10:29 AM

Copyright © Scott Lock | Powered by: