RDX is a Silver Sponsor of SQL Saturday #907 taking place in Pittsburgh on October 5, 2019. Several RDX SQL Server experts will be in attendance throughout the day, including Matt Nelson, RDX BI Developer and President of the Pittsburgh PASS Chapter, to network and answer some of your most challenging questions!
Additionally, SQL Server BI Developer, Russel Loski, will be presenting the following speaking session:
Managing ETL Change Using BIMLScript - Time and location TBD
Change is constant, especially with source files. Health care claims data files change at least yearly. You develop an SSIS package to load the source file. You meticulously identify each of the columns and map them to the targets. Your package runs fine for months. Then the file format changes. Again, you tediously select each column, etc. Wouldn't it be nice to simply document the structure of the file, the file's metadata, and generate the SSIS from that metadata? Your users demand the documentation anyway. If the file changes, you simply change the metadata.
During his session, Russel will import US census data to exemplify this methodology. He'll then create the SSIS package using BIMLScript and metadata. Additionally, he'll demonstrate how to generate an Azure Data Factory pipeline from the same metadata.
SQL Saturday #907 will be held at Pittsburgh Technical College:
1111 McKee Road, Oakdale, PA 15071
While you're there, don't forget to stop by RDX's booth for a chance to win a prize. Register here today!
Held in a hundreds of cities globally throughout the year, SQL Saturday is a free training event for data professionals that brings together dozens of SQL Server professionals for a day of networking and technical sessions designed to expand their skill sets.