We current use SQL 2005 Enterprise Edition and we have our SSIS package working great where the server names are picked from Environment Variables file stored on the server. We are now planning to use SQL 2008 R2 STANDARD edition and for some reason the
SSIS package which works great on SQL 2005 using variables is not working on SQL 2008 R2. It complains about not able to find the location/environment variables.
Question: Is the Environment variables thing supported in SQL 2008 R2 STANDARD Edition?
View Complete Post