Running DTS Packages

• kknudson

  SSCarpal Tunnel

  Points: 4986

  More actions

  October 1, 2003 at 1:16 pm

  #82610

  I'm no expert at DTS so bare with me.

  A developer is Excuting the package at his work station. It is issuing Queries into MF DB2 and posting the results onto the SQL Server.

  Am I correct it is actually running at his workstation, therefore punding the network.

  Or does it actually execute at the server.

  I ask as he references a DB2 DSN that does not exist on the server.

  KlK, MCSE

  
  KlK

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737403

  More actions

  Follow

  October 1, 2003 at 4:37 pm

  #476657

  Yes it is running on his workstation.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net