We want to disable xp_cmdshell on our server. However, on a particular database there is 1 stored procedure that writes a file using this (sp_create_bla bla_dlr_file) and it has exec xp_cmdshell embedded inside the sp. This stored procedure runs once weekly through a Sql Job.
I would like you to replace this with an SSIS package?
Once this is complete, I want to disable xp_cmdshell.
What exactly are the steps to accomplish this?