Author Archives: jwelch

T-SQL Tuesday #13–Data Quality and the Business User

Posted on December 14, 2010 by jwelch

This post is part of T-SQL Tuesday #13 – organized by Adam Machanic (Blog | Twitter), and hosted this month by Steve Jones (Blog | Twitter). The topic this month is “What issues have you had in interacting with the … Continue reading →

Posted in Requirements | Tagged , , | Comments Off on T-SQL Tuesday #13–Data Quality and the Business User

Processing Flat Files with SSIS at SQLSaturday #61

Posted on November 28, 2010 by jwelch

I’m looking forward to speaking at SQLSaturday #61 (#sqlsat61) in Washington, DC this coming weekend (12/4/2010). As usual for a SQLSaturday, there are some great speakers scheduled to present. I’ll be presenting on “Processing Flat Files with SSIS”, which goes … Continue reading →

Posted in SQL Saturday | Tagged , | Comments Off on Processing Flat Files with SSIS at SQLSaturday #61

Data Cleaner Component Published on CodePlex

Posted on November 19, 2010 by jwelch

If you saw my talk “Implementing a Data Cleansing Component for SSIS” at the PASS Summit or SQLSaturday #56 (#sqlsat56), you might be wondering where the source for the sample component is located. It’s published on CodePlex, and downloadable from … Continue reading →

Posted in Open Source | Tagged | Comments Off on Data Cleaner Component Published on CodePlex

Moving Data with SQL Azure and SSIS

Posted on November 12, 2010 by jwelch

I did a presentation on moving data to and from SQL Azure for SQLSaturday #49 in Orlando. In it, I reviewed a few of the options available for getting data into and out SQL Azure, including SSIS, BCP, and the … Continue reading →

Posted in SQL Saturday | Tagged | Comments Off on Moving Data with SQL Azure and SSIS

Recap of “Do You Know the Data Flow” at the Atlanta BI User Group

Posted on November 2, 2010 by jwelch

Last week I presented “Do You Know the Data Flow?” to the Atlanta BI user group. The meeting was well attended, with about 40 people present. The group was great, with lots of good questions and comments. I finally got … Continue reading →

Posted in User Groups | Tagged | Comments Off on Recap of “Do You Know the Data Flow” at the Atlanta BI User Group

Insert Parent and Child Tables with SSIS Part 2

Posted on October 29, 2010 by jwelch

Examine a different approach for inserting data into parent child tables with SSIS Continue reading →

Posted in SSIS | Tagged , | Comments Off on Insert Parent and Child Tables with SSIS Part 2

Inserting Parent and Child Tables with SSIS

Posted on October 29, 2010 by jwelch

Examines a simple pattern in SSIS for handling parent and child tables Continue reading →

Posted in SSIS | Tagged , | Comments Off on Inserting Parent and Child Tables with SSIS

QLSaturday #49 and #56 Recaps–A Little Different

Posted on October 28, 2010 by jwelch

SQLSaturday #49 My recap on SQLSaturday #49 is waaay overdue (sorry, Jack and Andy). It was nice to get a chance to present at the home of SQLSaturday, and I have to say, the amount of experience they have in … Continue reading →

Posted in SQL Saturday | Tagged | Comments Off on QLSaturday #49 and #56 Recaps–A Little Different

One Week to SQLSaturday #49

Posted on October 7, 2010 by jwelch

One week left till SQLSaturday #49 – there’s still time to register. I’m pretty excited about going, as it will be my first Orlando SQLSaturday. Also, it looks like a great lineup of speakers. I’ll be presenting on ways to … Continue reading →

Posted in SQL Saturday | Tagged | Comments Off on One Week to SQLSaturday #49

SQLSaturday #48 Recap

Posted on October 5, 2010 by jwelch

I presented at SQLSaturday #48 this weekend. It was a great event, and I thoroughly enjoyed it. K. Brian Kelley and the other organizers put on a great event. This was the first SQLSaturday that I’ve been to in a … Continue reading →

Posted in Uncategorized | Tagged | Comments Off on SQLSaturday #48 Recap