Hi rajarao.m,

when you trying to automate your package what error do you receive?

Are you using SSDT or BIDS?

Is the ".... identifying the files with some location_id ...." done via one SSIS's Loop containers?