Author Archives: jjames

How to Export BLOB data to Files in SSIS

Overview This topic will cover how to export data from BLOB fields in SQL Server and save those files out to the filesystem. This is accomplished within VB.Net code, but could just as easily be ported over to C#. DBServer: … Continue reading

Posted in Uncategorized | Comments Off on How to Export BLOB data to Files in SSIS

How to Extract SAP Data in SSIS

This tutorial will step you through installing the Microsoft SAP ADO.Net connector and extracting data from SAP, all via SSIS. But first, some background information. Overview This week brought me the unique challenge of extracting data from SAP within SSIS. … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on How to Extract SAP Data in SSIS

XML as Source in SSIS — Part 2

Now that our data is cleansed, onto loading the data into our table! The cleanest, most sane approach that I have found to parsing through XML within a SSIS script task is by utilizing Linq to XML. More information can … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on XML as Source in SSIS — Part 2

XML as Source in SSIS

XML is becoming increasingly popular in the workplace. Many systems are using it as a way to transmit data efficiently across the network. While XML certainly has its place, consuming it and deconstructing it can be a real headache. Unfortunately, … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on XML as Source in SSIS

Create XML Fragment in SQL Server

The XML datatype, first introduced in SQL Server 2005, can be very  handy when utilized properly. It is an industry standard, and with it, it is easy to import/export data across different servers, as well as different systems entirely. This … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off on Create XML Fragment in SQL Server

Exception: Microsoft.SharePoint.SPException: User cannot be found – Sharepoint 2010 Installation Failure

Today I found myself trying to install Sharepoint 2010 on my laptop running Windows 7 Enterprise. After reading all of the caveats about doing such a thing, I still needed to get this done. The post that I followed was … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Exception: Microsoft.SharePoint.SPException: User cannot be found – Sharepoint 2010 Installation Failure

Death by SQL…an Act in Two Parts

How common is it to run into performance issues with SQL Server? Daily?  Hourly? Maybe for you, it’s a common existence; and for that, I’m sorry. And how are some ways that you deal with performance degradation in SQL? I’d … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Death by SQL…an Act in Two Parts

How to Restore a Corrupt Database in SQL Server 2008 (Error 1813)

I ran into this issue the other day, and thought that I’d blog about it. I had copied a database from a co-worker (MDF files only, unbeknown to me) that I needed for my work. However, he forgot to include … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off on How to Restore a Corrupt Database in SQL Server 2008 (Error 1813)

How to Pivot Data in SSRS

Pivoting data can be tricky to say the least, whether the actual pivot is done in SQL Server or Reporting Services. There are cases to be had for both approaches, only to be constrained by your reporting design requirements. I’ve … Continue reading

Posted in Uncategorized | Tagged | Comments Off on How to Pivot Data in SSRS

How to Save Yourself From Yourself

Have you ever wished there was some sort of magic “undo” button for something that you just did? Maybe you didn’t really mean to delete all 10 million records out of your table. You just forgot a little thing called … Continue reading

Posted in Uncategorized | Tagged | Comments Off on How to Save Yourself From Yourself