How to replace xp_cmdshell with SSIS package in Stored Procedure
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?
Microsoft SQL Server
8/22/2022 - Mon
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst