SSIS Package in SQL Server 2008R2

• tripri

  SSCommitted

  Points: 1584

  More actions

  October 13, 2011 at 2:58 pm

  #244578

  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.

• R_S

  Ten Centuries

  Points: 1160

  More actions

  October 14, 2011 at 12:34 pm

  #1394818

  Have you followed the correct steps on how to create Parent-Child packages.

  http://msdn.microsoft.com/en-us/library/ms345179.aspx