Learn Azure Data Factory and SSIS and Save Money!

I am excited to announce two additional live, online training deliveries: SSIS Data Flows – 27-28 May 2020 SSIS Administration – 02-03 Jun 2020. Note: SSIS Data Flows is a prerequisite for SSIS Administration. SSIS Data Flows is the first two days of my four-day live, online From Zero To SSIS course – which I …
Continue reading Learn Azure Data Factory and SSIS and Save Money!

Announcing SSIS Data Flows and Administration Live, Online, Training Courses

I’m excited to announce fresh deliveries of two courses: 08-09 Apr 2020: SSIS Administration 13-14 Apr 2020: SSIS Data Flows Essentially, these courses are the first and second half of From Zero To SSIS. As I type (14 Mar 2020), both courses are on sale! Register for SSIS Data Flows or SSIS Administration today!These courses …
Continue reading Announcing SSIS Data Flows and Administration Live, Online, Training Courses

Staging Data Temporarily in an SSIS Data Flow

My friend Slava Murygin (@SlavaSQL) recently asked a question on Twitter: Populated query results into an object variable sucessfully used it in a data flow task, but can’t use it second time. Is there an easy way around? Tim Mitchell (Blog | @Tim_Mitchell | Tim’s post: Temp Tables in SSIS) and I engaged. You can …
Continue reading Staging Data Temporarily in an SSIS Data Flow