jordan.jeffrey (1/21/2016)
Koen Verbeeck (1/21/2016)
You sir are my hero!I only wish this article was published yesterday, when I was creating environments on the new production server 😀
Keon, I appreaciate that you took the time to read my my post and would find it useful.
Yes. I was frustrated for some time with the SSIS environments and the inability to script them.
I knew I could use T-SQL or PowerShell to get all the info I needed from the catalog, but I never got around to actually writing such a script.
So now I'm glad someone else did the work for me 😀
Thanks again!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP