Wow!
After many weeks of searching, I finally found a decent article on how to move an SSIS package through different environments (Dev, Test, & QC) on the same server. The article is clean, concise, detailed and has pictures even! @=)
IMHO, the article is well written. Especially as it doesn't do the "broad overview" that all the other SSIS source material or articles do. This one actually gives good instruction on how to do what for those of us who need something a little more definitive than "Just use an indirect environment variable".
Anyway, here's the website of the article. I hope it helps someone else as much as it's helped me.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
After many weeks of searching, I finally found a decent article on how to move an SSIS package through different environments (Dev, Test, & QC) on the same server. The article is clean, concise, detailed and has pictures even! @=)
IMHO, the article is well written. Especially as it doesn't do the "broad overview" that all the other SSIS source material or articles do. This one actually gives good instruction on how to do what for those of us who need something a little more definitive than "Just use an indirect environment variable".
Anyway, here's the website of the article. I hope it helps someone else as much as it's helped me.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
