Category: Business Intelligence

Capture SSIS Package Execution Status 1

Capture SSIS Package Execution Status

Executing an SSIS package from within a stored procedure is not an uncommon request.  People sometimes scratch their head when it comes to figuring out if that package ran successfully or not though.  There may be...

Control Flow vs Data Flow 1

Control Flow vs Data Flow

After my first day of SSIS training my boss walked into the office and said to me, “how was the first day of class”.  To which I responded, “great!”  Then asked me, “so what...