We went with staging option(internal blob) enabled as part of the copy activity which resolved the DNS issue. Internally, the copy activity first created file in blob container and then uploads files to external azure blob storage.
Thanks all