Uncategorized

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…

Read More

No Picture

SQL Saturday 125 OKC

This weekend I traveled three hours north to Oklahoma City to participate in SQL Saturday 125, the second annual event hosted by the OKCSQL group. Ryan Adams, Russ Loski, John Sterrett and I hit the road midafternoon to give ourselves time to make it in time for the speaker dinner on Friday evening.  I’ve made several trips before with Ryan…