Thank you for your response. We did get a resolution by defining the dns servers ip address on the public network card in tcp/ip properties

Thank you for replying. We are moving just this Database to it's own sql instance due to performance issues. The dts packages are run off of a application server so...