posted 9/22/2010 by timmurphy - Views: [2407]
Sometimes you may need to Work Offline in SSIS. The option is found on the SSIS menu once you open a Solution.
This can be handy if you are working with sources which are temporarily unavailable or have changing credentials. I had a situation (a mixture of development and production environment) where my username got locked out of an AS400 connection because the validation process in the SSIS package was hitting the server over and over and eventually triggered a lockout. Working Offline is a great option in this case.
While working offline, if you try to preview data in a source you will get this error:
Exception from HRESULT: 0xC0202022
Hopefully you will remember that you are working offline and not try to “fix” things that aren’t broken, like someone I know. Just unselect Work Offline and if your sources are available, off you go (or on you go).
I hope this helps you sometime.
This is also a great setting if you are working with a large SSIS package that has lots of connections in it and you hate waiting 5 min for it to validate the connections every time you open the package.
This offline option is very handy. Thanks for sharing it.
"This is also a great setting if you are working with a large SSIS package that has lots of connections in it and you hate waiting 5 min for it to validate the connections every time you open the package."
Like it a lot... Validating.... ^^