Post reply

SSIS in multi domain network

  • March 10, 2010 at 3:36 am

    #156763

    Guys & Gals

    I have an SSIS package that is gathering files from a number of servers within a single windows domain at the moment, moving forward this is going to change to having to pull the files from multiple windows domains and placing them into one server that is local and another that is in another domain. (I have included a diagram of what I am trying to do.)

    My question is what are peoples suggestions for putting this in place, I am leaning towards FTP as there are no trusts between the domains. By taking information from a control database I would be able to add/remove source/target withough needing to mess with the package.

    Any comments/suggestions appreciated

    John

  • March 10, 2010 at 4:30 am

    #1131253

    I guess my first thought is that if these are all windows machines FTP seems kind of silly. Your whole issue is security contexts..

    I would think a Script Task would be able to use the System.IO namespace and get the files, if not directly then with impersonation. You would need some repository of credentials (probably a table) and need to provide for some encryption of the passwords which you would need to do for FTP as well. Then you could just copy the file and not deal with http://FTP..

    CEWII

  • March 10, 2010 at 4:51 am

    #1131260

    Cheers for that, I had not thought about using the script task to do that. I'll have to explore things a bit more.

    🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply