hey guys,
i have this Applicaation that is hosted on one server. This makes a
call to a DTS which is on teh DB server on another Domain which is
behind a firewall. When the app calls it the call never excutes the
DTS.

Thought could be a problem with the DTS but the DTS has error loggin
but that dosent show anything since the package never executed.

If i change connection string to the devp serve which is on the ame
domain, then not an issue.

if i put the application in the same server as the DB no issue.

Can you either tell me whatz wrong and a workaround for the same

ty
Zach

Can I do this?
is there a set-based solution to this task?
Combining Two Tables ?
Can use Subquery like this?
how to check if #temp table exists?