I believe I've worked out my issue.

Thanks anyways.

marcel.eppel (5/24/2013)

---

Easy way to implement this would be the following:

you create two ssis packages. One is the main package and responsible for control flow. It takes the parameters and passes...

The @SourceSQL and @Destination values would be passed into a SSIS Package Parameter, via a job call....

Thanks Lowell, that's what I thought was the case. The setup as-is is not causing an issue, I just became curious while working on the warehouse documentation as to whether...

Thanks for the excellent article, and the wonderfully useful script. I can already think of a number of instances where something like this could have been huge time savers.

One thing...