Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2007
    Posts
    44

    Unanswered: ERROR EXECUTING ssis PACKAGES

    HI ALL.
    I HAVE A PACKAGES WHICH THEN EXECUTES CHILD PACKAGES. tHE CONNECTION managers are specified. and environmental variables are saved on xml file. when i run(debug) parent packages on BIS , it gives me error saying the "error loading package file "childpackage_name.dtsx1st ".the system canot find the file specified.

    how ever if i build solution it gives me output saying build successful..
    i do not ge this..
    anyhelp guys.

  2. #2
    Join Date
    May 2007
    Posts
    49
    If you are using execute package task to execute package from package than it loads child package at run-time, compiler does not check whether child package exists or not so it is going to build successfully even if child package does not exists.

    Where have you deployed your child SSIS package? filesystem or sql server ?

    Mihir
    --------------------
    DB Team @ Clarion
    Clarion Technologies
    (SEI CMMI Level 3)
    Pune, India
    www.clariontechnologies.co.in
    www.vEmployee.com
    Mihir Mehendale
    DB Team @ Clarion
    Clarion Technologies
    (SEI CMMI Level 3)
    Pune, India
    www.clariontechnologies.co.in
    www.vEmployee.com

  3. #3
    Join Date
    Jun 2007
    Posts
    44
    i deployed to filesystem. and i have .configdts path file manually copied to the same folder( which has all the user variables and connection string path).
    and one more question,

  4. #4
    Join Date
    Jun 2007
    Posts
    44
    thanks Mihir,
    so how should i approach this., i wan't the child packages to use the variables and connection string on connection manager. i have mapped all the user varibales on parent and child packages. and i have it also on .dtsconfig file as well.
    i do not know where do i start from.
    Thanks again
    Derek

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •