October 21, 2021 at 10:52 am
I have an SSIS package which outputs a flat file to the file system into a "staging" folder.
The package then runs a File System Task to move this file from the Flat File Destination "staging" location to another "collection" path specified in an SSIS Parameter.
The package works successfully.
However, the resulting file that SSIS puts into the final "collection"/destination folder does not inherit the NTFS permissions of the destination folder.
If I disable the Move File step and then manually copy the file using Windows Explorer from the Staging folder to the Collection folder, the permissions correctly inherit.
The same issue applies if I use a Copy File or Move File in the File System Task.
I cannot see anything on the web about configuring File System Tasks to inherit or not inherit permissions.
Has anyone run into this problem and can advise how to resolve?
October 21, 2021 at 11:48 am
Not a direct answer, as I never use the FST, but maybe try doing the file move in a Script Task and see whether the outcome is any different.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 22, 2021 at 1:11 pm
This is a windows issue - when you 'move' a file from one folder to another the file settings are maintained from the source whereas performing a copy of the file inherits from the destination.
This is generally seen when you move a file into a compressed folder - it will not be compressed. Copy the file and it will be compressed.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 22, 2021 at 2:10 pm
Hi Jeffrey, this wasn't born out in testing.
Changing the File System Task from Move File to Copy File has the same problem
Also, manually copying manually moving the file didn't have the problem so I can't see how it's a windows issue.
October 22, 2021 at 3:03 pm
https://serverfault.com/questions/31709/how-to-workaround-the-ntfs-move-copy-design-flaw
Here are just a few articles about this issue.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply