I just downloaded and installed Office 2016 Preview from our Office 365 tenant — nothing new with how you download and install 2016, but I still remember the days of getting Office media on CDs, so I always appreciate how easy it is now with O365 – and I like it. One of the things I noticed I haven’t used before was posting a blog post directly from Word. I don’t use this feature (though it has existed for many years in Word), so I thought I would give it a whirl. Unsurprisingly, this post was written in Word 2016 … Read More
The IDM team at M&S Consulting is excited about Microsoft’s upcoming release / update / rebranding of Forefront Identity Manager to Microsoft Identity Manager. We’ve stood up a lab using the latest (as of this writing) CTP3 and so far have enjoyed playing around with the various new features and wanted to share our quick thoughts. Outside of the modernization and support for the latest platforms and infrastructure, such as, Server 2012 R2, SharePoint 2013, SQL Sever 2014, Microsoft has included several new features to add to the product offering. These include Privileged Account Management / Access and Cloud and … Read More
If you are a heavy SharePoint user, there is a chance you are still running SharePoint Workspace 2010. Today, after months of this tool working flawlessly, I suddenly ran into some errors during syncing and thought I would share the resolution. Details: Harmonica Version Not Found I started with this error. After disconnecting the library and trying to reconnect, I received the CSI error 123 (below). More info: http://support.microsoft.com/kb/2754412 Details: CSI error 123 I understand this can happen if temporary data is corrupted. I ran the following command on my 64-bit OS: “%SystemDrive%\Program Files (x86)\Microsoft Office\Office14\groove.exe” /clean /all At this … Read More
At last, the long awaited Windows 8.1 update is here! Windows users can now get back to using the familiar ‘Start Button’ we are all used to. Before I get into the new features of Windows 8.1 both ascetically and behind the scenes, I’d like to talk about the install time and process. For starters, the install time isn’t exactly speedy, and instead of telling the user what is being updated, Microsoft has chosen to to use phrases like ‘Getting Ready’ , ‘Setting up a Few More Things’, and ‘Taking Care of a few Things’. Once the install is complete, the … Read More
It’s not just web 2.0 developers making the push away from IE6 anymore. Microsoft is publishing the stats, and even they want people off of Internet Explorer 6 (IE6). Join the cause by pasting your own “STOP using this out-of-date browser” banner (provided by Microsoft): <!– [if lt IE 7]> <div style=’ clear: both; height: 59px; padding:0 0 0 15px; position: relative;’> <a href="http://windows.microsoft.com/en-US/internet-explorer/products/ie/home?ocid=ie6_countdown_bannercode" alt=""><img src="http://www.theie6countdown.com/images/banners/warning_bar_0000_us.jpg" border="0" height="42" width="820" alt="You are using an outdated browser. For a faster, safer browsing experience, upgrade for free today." /></a></div> <![endif]–><!– [if lt … Read More
For some reason, SSIS’s XML Data source does not allow you to directly access root level attributes. Therefore, we’ve got to use a XML Task and variables in order to pull this data in. Create a variable for every attribute, use the string data type (change later in data flow if need be) Use the following example (fill your own Xpath in the Second Operand) This example will only pull in one value. Should there be multiple attributes with the same name, you’ll have to use a Foreach loop.
At some point you may need to use Xpath from within a script task rather than using Integration Services built in XML Task’s Xpath functionality. Here’s how I implemented it. The primary limitation is that it will only return a single value, but this can be adjusted to return multiple values easily. Chances are you’ll already be using a script task, but incase you don’t, start with a standard Script Task (this can be either a Control Flow Script Task or a Data Flow Script Task). Don’t forget to set your ReadOnly / ReadWrite variables. Here’s the boilerplate code for using … Read More
Reading from variables to augment rows with data from variables isn’t readily apparent in SSIS. A workaround I found was to use a script task right before your OLE DB Destination and access the SSIS variable objects directly. Script Task Setup Start with a standard Script Task in your data flow. Add columns to your output in the ‘Inputs and Outputs’ tab, set the names and output data types appropriately Access Variables in your ‘main’ script section by using the following code IDTSVariables100 vars = null; //Gets reference to the SSIS Variables this.VariableDispenser.LockOneForRead(“session”, ref vars);//Locks the Variable in quotes, for Read … Read More