Hi Gurus,

I have 15 child packages calling from master package.

i created 3 sequence container and kept 5 child packages in each container. Packages are running fine when i ran the all packages individually and individual sequence container. But when i ran the whole master package getting error .

Could you please help me here by giving the best approach.

Whats the error you're getting?

How are you invoking the packages? Using execute package task?

Are you using SSIS 2012 deployment model or legacy deployment model?

Hi Visakh,

I am using execute package task in ssis 2012.coming to error, i have seen DIFFRENT error while running package different times. in each package i created global temp table Tto store  DFT data.

Sorry that doesnt help

What do you mean by different error? Are you passing any parameters from calling package to child package? Using project reference or external reference?

I am passing data base connections with variables from master to child packages

• Edited by vamsi1980 3 hours 54 minutes ago

I am passing data base connections with variables from master to child packages

You mean through parent package configuration?

I am working with SSIS 2012. created parameters in child package and binding with parent variable in execute package task.

I am working with SSIS 2012. created parameters in child package and binding with parent variable in execute package task.

That sounds fine

Did you check if values got passed correctly to child packages by putting breakpoints inside?