Where''s my file?

• Dan Potter

  SSC Enthusiast

  Points: 190

  More actions

  January 31, 2006 at 7:37 am

  #68643

  Hi All,

  I have a DTS package that calls another DTS package. Pkg 1 polls a directory named in a GV and passes it to Pkg 2 if a file is found.

  I can execute the whole suite using the DTS packages but if I schedule the job to run every ten mins I get a success message but my table is not populated.

  I am not using a UNC path (at the moment -the set up is strange here and I need to get someone in Germany to make the necessary change!!!!).

  Does anybody have anythoughts?

  TIA,

  Dan

• Dan Potter

  SSC Enthusiast

  Points: 190

  More actions

  February 1, 2006 at 4:07 am

  #618072

  FYI: Solved

  The dir I was looking at is encrypted and the SQL Agent was running under a different username.

  Stupid, huh?

  D.