DevConnections 2016

Speaking at DevConnections 2016

I am excited to share that I will be presenting at the DevConnections conference in Las Vegas in October of this year. This is my fourth (if I remember correctly) time to have spoken at DevConnections, and the first time I will have delivered a full-day workshop there. This year I will present one workshop and two regular presentations: Building…

Get Your Email Out of my ETL

Get Your Email Out of my ETL

Question from someone in one my recent classes: “What tool do you use to send email from ETL processes?” My response: “I don’t.” The tl;dr version of this post is I let my extract-transform-load processes do just ETL, and leave notifications to the scheduling system where they belong. Get Your Email Out of my ETL Before you read any further,…

SSIS Training for Summer 2016

SSIS Training Classes for Summer 2016

If you are looking for affordable, high-quality training on SQL Server Integration Services, you may be interested in one of the two full-day workshops I have scheduled for August of this year. I’ll be taking my popular course Building Better SSIS Packages on the road to Baton Rouge, Louisiana and San Antonio, Texas. This course is designed for the data…

Custom File Delimiters in SSIS

Using Custom File Delimiters in SSIS

File-based ETL is usually dull. Most systems generate (or expect to consume) files that are delimited, with a common field separator such as comma, tab, or pipe. However, occasionally you’ll get an oddly formatted file with an unusual delimiter. Although it’s not obvious in the Visual Studio designer, SSIS is capable of consuming and generating files with custom delimiters. In…

SSIS 2016

Kicking the Tires on SSIS 2016

Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services in SQL Server 2016. The current beta of SSIS 2016 has some exciting new features that I think you’ll like. The recording of that webinar is below. Enjoy!

Advanced SSIS Training

Advanced SSIS Training Course Preview

If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and me in the Washington, DC area for our 4-day Advanced SSIS classroom training course. This course will be held December 7-10 in Reston, VA (just outside of DC). I’ve recorded a brief intro below to give you a glimpse into…

SSIS 2016

Webinar: Kicking the Tires on SSIS 2016

The next version of SSIS is on the horizon. Are you ready? In next Tuesday’s webinar, I’ll be reviewing and demonstrating the new features of SQL Server Integration Services. Microsoft recently released the CTP bits for SQL Server and SQL Server Data Tools, both of which show several useful changes to SSIS. Registration is now open for this webinar.

Balancing balls Newton's cradle on grey background

Building Better SSIS Packages Class in Dallas

I’m happy to announce a new, full-day class in the Dallas area next month. I’ll be presenting my Building Better SSIS Packages course on Friday, October 2nd at the Microsoft campus in Irving, Texas. This course is a preconference seminar for SQL Saturday Dallas, which will be held in Arlington, Texas the following day (October 3). Registration is open for…

Downloading SFTP Files with SSIS

Accessing SFTP with SSIS

If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to download a file stored on an SFTP (secure FTP) server, but connecting to SFTP with SSIS is not natively supported. There is a built-in FTP task in Integration Services, but it is very limited in its functionality and will not…

Synchronous Processing in the SSIS Script Component

Without a doubt, the most versatile data flow tool in the SSIS arsenal is the script component.  This control grants ETL developers complete control over the flow of data, leverages the full power of the .NET Framework namespaces, and can be used as a source, destination, or transformation in data flow operations.  Within the script logic, one can perform complex…