Tag Archives: SSIS.Catalog

Useful Tips in using BIML in BidsHelper

This is a follow up post on the first post my colleague and owner (Louw Fouche) of sabigdata, wrote around BIML and generating SSIS packages. This article will focus on some of the insights we gained using BIML for Source to … Continue reading

Posted in SQL Server 2012, SQL Server 2014 | Tagged , , , | Leave a comment

Stop SSIS Package execution in SSIS.Catalog

This article is about explaining how to cancel or stop a job that was executed directly from the SSIS.Catalog. I executed a SSIS Package directly from the SSIS.Catalog where I subsequently had to cancel the process. My research lead to … Continue reading

Posted in SQL Server 2012, SQL Server 2014 | Tagged , , , , , , | 1 Comment

SSIS Parameters using SQL Server 2014

I am working on a BI Project to load a daily snapshot of data into a BI database. A date parameter drives the whole ETL where a daily Snapshot of data loads. At first glance we wanted to use a … Continue reading

Posted in SQL Server 2014 | Tagged , ,