Thanks for the input. It is very appreciated.
>Check
http://msdn2.microsoft.com/en-us/library/ms345193.aspx>
>>One thing that has been frustrating, MS did a great job in distancing the user from being the owner of objects (tables, procedures, etc.), as that caused problems when a person would leave. In creating SSIS packages, though, the package is created in my own personal home directory structure. I have moved it to be under the SQL structure, but when I go to schedule the package (in the general tab of the new job step window), it gives me an invalid path error. It is also a clustered server, so the path may not be visible to both servers on the cluster (although the data and log files are there).
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.