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)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
October 10, 2017 at 8:43 am
Or PowerShell. Copy-File will help you.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply