October 13, 2011 at 2:58 pm
HI,
I have Two packages
Parent Package and Child Package
Child package is pulling data from Database DB1 on Source server to my database DB2 on my local machine
When Child package is exeuted seperately it's running fine
now i have variables in parent package which populates the connection strings for child package.
When i run parent packge it popultaes the connections for child packages and executes that child package
Here when i run the parent package child package hangs up at validation. It's hanging the entire package. So when i run sp_who2 on my database if ound and SPID in suspended mode and blkBy -2 on my Database.
How can i resolve this issue as it we are not clear exaclty what is happening with that SPID.
October 14, 2011 at 12:34 pm
Have you followed the correct steps on how to create Parent-Child packages.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply