DTS package and Firewall

Hi all, I have some DTS packages that are used to import /export data to a
SQL box located outside in a DMZ behind a firewall.

We need to open up a port in the firewall so that the Internal Server can
communicate (Execute DTS packages against) with the SQL box located outside
the DMZ.

How do I find out what Port we need to open so that the Internal SQL box can
communicate with the external SQL box?

Thanks in advance
Mark"Mark" <markjones@.n0Sp8mTAIRAWHITIdotAC.NZ> wrote in message news:<ZFxoc.4117$XI4.156748@.news.xtra.co.nz>...
> Hi all, I have some DTS packages that are used to import /export data to a
> SQL box located outside in a DMZ behind a firewall.
> We need to open up a port in the firewall so that the Internal Server can
> communicate (Execute DTS packages against) with the SQL box located outside
> the DMZ.
> How do I find out what Port we need to open so that the Internal SQL box can
> communicate with the external SQL box?
> Thanks in advance
> Mark

In general, a DTS package is like any other SQL client:

http://support.microsoft.com/defaul...2&Product=sql2k

If you have a variety of tasks in your package (ActiveX, FTP etc.)
then you might require additional ports to be opened, but that depends
on exactly what those tasks do, what protocols they use etc.

Simon