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