February 26th, 2011 
One of the built in data sources in in SSIS is an XML document. I started writing a package to pull data from XML stored in a SQL table. I noticed that there were several little gotchas that I had to work around to get the data the way I wanted. The XML file can [...]
Archive for February, 2011
Parse XML in SSIS
Posted in SQLServerPedia Syndication, SSIS 
Tags: Microsoft, SQL, SQL 2008, SQLServerPedia Syndication, SSIS, XML, XML Source 
No Comments »Looping through files on an FTP server
I have always know that that SSIS has an FTP control Flow task, but I have never tried to use. Turn out that the task is fairly limited and can be a pain to work with. I am attempting to get a list of all files, in a folder, on an FTP server. The FTP [...]
Posted in SQLServerPedia Syndication, SSIS Tags: FTP, Microsoft, SQL, SQL 2008, SQLServerPedia Syndication, SSIS 1 Comment »What Are We Doing Here, Exactly?
There’s a secret about being a developer that I forget all the time. I know it, and I should remember it, but in the daily drama of life, I tend to forget it. Here it is: Knowing how to do something is the easy part. Knowing what to do… that’s hard. Technical skills allow me [...]
My iPhone, Cloud Storage and OneNote
When I am at work, you will always see me with a notepad and pen by my laptop. Any activity with the word “conference” in it; conference call, conference room meeting, a conference in Seattle, I will definitely have paper and pen in hand. Call me old school, but I find writing things on a [...]
