Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.
Sign up to join this community
When doing a "Operation: Copy file" using a "File System Task", is it possible to preserve the "Owner" attribute on the file?
What happens: The destination file gets the "Owner" as the user running the SSIS-package.
What I want: Keep the original owner as the owner of the copied file.
As I understand it, a copied file is considered to be a new entity, and therefore its owner will be the user or process that created it. Interestingly, a moved file will retain all of its attributes.
If moving (rather than copying) is an option, that should work for you. If not, you'll have to find a way to change the attributes on the newly copied file. Some copy utilities (such as Robocopy) have switches that allow you to retain some or all of the attributes. I'm not that familiar with SSIS, but maybe there's a way to call a batch file rather than use the native copy command?
