Post reply

Where''s my file?

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply