Executing an SSIS Package in a Container

Andy Leonard continues a series on SSIS and Docker by executing a package in a container:

In this post, I show my next step: executing an SSIS package in a container. Spoilers:
1. It’s more work than you think; 
2. This is merely one way to do it; and 
3. This is not my ultimate goal.

Read on to see how to do this.

Related Posts

SSIS Design Preferences

Meagan Longoria systematizes a set of preferences regarding Integration Services package and ETL process design: – Every table should have InsertDateTime and UpdateDateTime columns. The UpdateDateTime column should be populated with the same value as the InsertDateTime column upon creation of the row, rather than being left null.– Whatever you use to create tables, include […]

Read More

Exposing Multiple Docker Ports

Steve Jones shows how to expose multiple ports when spinning up a container: I was working with containers recently with Jenkins. I didn’t want the server process running on my machine all the time, but I did need to allow some communication. Jenkins uses 8080 by default, but agents need another port. I figured there […]

Read More

Categories

April 2019
MTWTFSS
« Mar May »
1234567
891011121314
15161718192021
22232425262728
2930