Post reply

Cannot find package from variable

  • March 12, 2008 at 4:54 am

    #154189

    Please help. Posted yesterday but no answers.

    I have a connection string for a child package defined as:

    @[User::CRDirectory] + @[User::PackageCRSisdomDrive] (sorry about the emoticon - read colonP instead)

    Each of these variables is blank in the parent package, and populated by a config file at run time

    There are 3 config files. CRDirectory is specified in the config file listed first in the agent job, and PackageCRSisdomDrive is in the second config.

    CRDirectory is given the value:

    E:\Mirror_Files\DEV\GOODIES\COMMON ROUTINES\

    PackageCRSisdomDrive is given the value:

    CR_Sisdom_Drive.dtsx

    The error message from the job is:

    Error 0x80070003 while loading package file "E:\Mirror_Files\DEV\GOODIES\COMMON ROUTINES\". The system cannot find the path specified.

    The command line in the job is:

    /FILE "E:\Mirror_Files\DEV\SOLUTIONS\Daily_Tower_Data_Quality\Daily_Tower_DQ_Parent_Pkg.dtsx" /DECRYPT /CONFIGFILE "E:\Mirror_Files\DEV\GOODIES\DEV_Environment.dtsConfig" /CONFIGFILE "E:\Mirror_Files\DEV\SOLUTIONS\Daily_Tower_Data_Quality\DEV_Daily_Tower_DQ.dtsConfig" /CONFIGFILE "E:\Mirror_Files\DEV\SOLUTIONS\Daily_Tower_Data_Quality\DEV_DTS.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

    I've checked and re-checked all the obvious things like spelling mistakes.

    The only thing I can think of, is that the package isn't added into the project. I didn't want to do this as it creates a copy in the directory the rest of the project is in. The package will be a common routine called by a number of jobs, and I don't want spurious versions kicking around.

    Any ideas, anyone?

    TIA

  • March 12, 2008 at 6:58 am

    #788502

    I've posted this twice here, and once in the general section. Quite a few views but no responses.

    I've been trying to crack this on my own since yesterday. I have no colleagues or peers to call upon, only 4 books and the internet. Can anyone recommend any other good sites, where I might ask the same question?

    Thanks

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

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