Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
renuka.popli
Starting Member
3 Posts |
 Posted - 2008-05-12 : 09:17:08
|
| Hi All I have parent package which is having the Execute Sql task , which execute the script provided by file connection , after that it calls the child package thru Exceute Package task , I have set the Parent package's Transaction property as "Required" & child's as "Support" , as I run the package child package gets hang .. but it started running when I put the direct input instead of script in my parent package . Can you plz help why this is happening & what is the solution because I require that script file Kind RegardsRenukaRenuka.M.Popli |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-12 : 10:21:08
|
| What is the script doing? |
 |
|
|
renuka.popli
Starting Member
3 Posts |
Posted - 2008-05-13 : 02:24:26
|
| the script is having only delete sql statement only which clean up all the tables before doing anything , it locks all the tables due to that I can't able to access that table in child table ..RagardsRenukaRenuka.M.Popli |
|
|
|
|
|
|
Transaction fails