October 10, 2017 at 7:59 am
I'm Extracting data into a file, I have o send the same file to multiple directories. So far it's easy for me to output it into one file directory, and I'm thinking I can take same folder and copy it into other 4. Please on how can I do this or even the better way.
October 10, 2017 at 8:11 am
hoseam - Tuesday, October 10, 2017 7:59 AMI'm Extracting data into a file, I have o send the same file to multiple directories. So far it's easy for me to output it into one file directory, and I'm thinking I can take same folder and copy it into other 4. Please on how can I do this or even the better way.
1) Data flow to file
2) Copy file to other folders
(Use File System Tasks or a Script Task to do this)
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 10, 2017 at 8:43 am
Or PowerShell. Copy-File will help you.
October 10, 2017 at 11:00 am
Steve Jones - SSC Editor - Tuesday, October 10, 2017 8:43 AMOr PowerShell. Copy-File will help you.
It would be nice if there were a native 'Execute Powershell' task in SSIS, but there isn't, so you'd need to use a generic Execute Process task to achieve this.
I prefer Script Tasks mostly because you get comprehensive debugging built in.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply