Firewall ports for DTS

[Hondy]

Hi

If we have a SQL server in a DMZ and I need to import a file from our internal network using DTS. Is there a particular firewall port that I need to open? is it the same as file browsing if thats what I'm asking the DTS to do?

Thanks

PS - I can appreciate this may not be the best way from a security PoV but I'm just exploring options.

 

[mrdenny]

DTS doesn't use any special ports. If you are accessing a file on the file system you'll need to open the SMB ports.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog