Hi, I'm using SQL Server 2008 for a reporting system and wanted to enable the xp_cmdshell through the Surface Area Configuration manager but was unable to find it. I have enabled it through sp_configure but was wondering if the "Surface Area Configuration Manager" no longer exists on SQL Server 2008 and onwards? Additionally, even though I have enabled xp_cmdshell (which I understand is a security risk), I still get an error that its not enabled when I run a DTSX package which basically grabs a file from an FTP using xp_cmdshell. Any advice would be helpful. Thanks, S
Did you run 'RECONFIGURE' after you enable xp cmdshell? Below is what i usually run to enable any of the advanced options in my servers: EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE GO EXEC sp_configure 'xp.cmdshell', 1 GO RECONFIGURE GO EXEC sp_configure 'show advanced options', 0 go RECONFIGURE GO
Why to use xp_cmdshell in SSIS package for loading a file from FTP? I suggest you use a **`FTP Task`** to transfer files from/to FTP site. And even you do not want to use the FTP Task, you can use the **`Execute Process Task`** to launch command line ftp client to grab the files.