August 3, 2013 at 7:00 am
I have an SIS package that I'm creating on one server that is outside of the network.
I am needing to send a file to another server inside the network and need to pass the User name and password.
The destination server is not a SQL server and the file I'm sending is a csv file.
Any suggestions would be greatly appreciated.
Thanks in Advance
Wayne
August 4, 2013 at 1:16 pm
If I understand correctly, you want to write an output CSV file to the file system on a destination server on a different network. The easiest way to do this would be to create the output file locally (on the server where the SSIS package is executed) and then use FTP to transfer the output file. This, of course, depends on having FTP running on the server to which the file will be transferred.
You could possibly create a mapped drive to do this, but I avoid this in SSIS as it doesn't always behave like you expect it to.
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
August 4, 2013 at 5:45 pm
Thanks Tim,
Unfortunately this is not an FTP server.I was hoping it was, so I could have used the FTP task.
Thanks
Wayne
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply