Tag

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...

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...

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...

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...

In order to save your SSIS package built using Business Intelligence Development Studio (BIDS) to Integration Services MSDB, you’ll need to: In BIDS, right-click the solution and select Properties Under Deployment Utility, change the CreateDeploymentUtility option from...

Occasionally, I’ve needed to pull XML from the internet via an URL. This allows you to dynamically pull XML from sources than your local.In order to do so, you’ll need a string variable (to populate with the XML from the internet) and the code below in a Script Task. Every time...

Here are quick shortcut keys I use when using SQL Sever Management Studio’s query editor (I happen to be on version 2008 R2). Comment selection: CTRL-K, C (while holding CTRL) Uncomment selection: CTRL-K, U (while holding CTRL) New Query Editor Window: CTRL-N Find: CTRL-F...

I talk to many customers who have trouble understanding the Microsoft SharePoint versions that have existed since around 2003, so I have provided a very simple chart with the various naming conventions used in the industry.