hi Monalv
Thank you for the update. I understand proxy account has security. However I wounder think why the option given to add connection manager details will overwrite access method when run through the SQL agent. Do you know what aspects package will run using connection manager please ? further more we need to hard cord the password as well. If decide to change the password then those are stop working unless change it with in SQL server proxy user level. wired way. do you think have any solution from MS
thanks