March 17, 2008 at 7:07 am
When I exectute from cmd prompt (dtexec) an SSIS package on a local server, it takes about a few seconds to complete. When I execute the same package from a remote machine it takes about one minute. Any clues why is this happening;
Thank you
March 18, 2008 at 3:45 pm
I'm no expert, but can suggest a couple of possibilities. If you're running the package locally but accessing a remote db, or simply returning a large result, your wide-area network may be slow enough to make a perceivable difference. Do non-SQL tasks (like copying a file) also take significantly longer?
Another thing that could be affecting your timing is access authorization. If your remote machine has to go check with a domain controller to see if your ID is allowed to do whatever your task is, that can take some time.
Good luck with this.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply