A Good Template

A Good Template
Photo by Scott Graham / Unsplash

I am moving tables in a database from one server to another with an SSIS package. There are some difficulties with the information though. It's currently 62 tables, and will likely grow.

The best way to tackle this was with a rock solid template object. This allows me to speed up development and get the tables moved sooner. It is still taking some time to accomplish each one. Today with the template I was able to setup 20 of the tables for automated data transfers. I am figuring with meetings and speeding up as I iron out workflows I will be able to keep up with 20ish tables a day.