Author Archives: jwelch

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

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

Processing Flat Files with SSIS at SQLSaturday #61

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

Data Cleaner Component Published on CodePlex

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

Moving Data with SQL Azure and SSIS

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

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

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

Insert Parent and Child Tables with SSIS Part 2

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

Posted in SSIS | Tagged , | Comments Off

Inserting Parent and Child Tables with SSIS

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

Posted in SSIS | Tagged , | Comments Off

QLSaturday #49 and #56 Recaps–A Little Different

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

One Week to SQLSaturday #49

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

SQLSaturday #48 Recap

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