We have a table in the master database that stores file paths information. Instead of having to still use this we want to start using FTP in SSIS. Instead the file path should be obtained from the dashSettings table in the dashConfiguration database not in the masters database. If the process works, we will then turn off xp_cmdshell.
Any suggestion, would really be helpful.