Schedule DTS package across NT Domains

[susanma]

Please Help if you can. We have a regular data transfer requirement from a sql database on server1 in domain1 to sql database on server2 in domain2. There is no trust relationship between the domains and there is a firewall between the two.

How can we get this to work?

many thanks, sue

 

[Sammy145]

Simple answer you cant you need to allow TCPIP (port to be open) so it can go across domains

The only alternative i can think of is transfer the data into a file over to domain 2 VIA FTP and then schedule that DTS on Domain 2 to pick up the file


sam

 

[Sammy145]

To use the above method you will have to ask the Networks guys (if have any to setup FTP folder)

you might try looking here

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_1zuc.asp

http://www.sqldts.com

sam