Thanks for the reply.

The package is getting executed when i execute it manually either from BIDS or from the management studio Integration services. but if i call it from a...