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)
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.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy