Dave Coats (12/10/2009)
I have found that storing them to msdb on the server by choosing "File | Save Copy of Package AS" works best. Important: You have to choose "Rely on Server Storage and roles for access control" for Protection Level in the Save As window. By doing it this way, you don't have any problems running the package from jobs and don't have to use a proxy account. Does anyone else do it this way?
Dave,
That is exactly how I do it. When I was in SSIS training, another attendee mentioned your described approach to getting around the credentials issue and I've done it that way ever since. So there are at least 3 of us! Unless that was you in my class. 😛
Terry