Post reply

passing a User Name and Password in SIS package when sending to another server

  • August 3, 2013 at 7:00 am

    #275852

    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

    #1638493

    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, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • August 4, 2013 at 5:45 pm

    #1638505

    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