SSIS FTP to read file path inside SQL Server database table

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.
FavorableAsked:
Who is Participating?
 
Alpesh PatelAssistant ConsultantCommented:
To get the file path from SQL Server. Query the Table and get that value in variable and create Dynamic FTP File connection using Expression.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.