• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 454
  • Last Modified:

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.
0
Favorable
Asked:
Favorable
2 Solutions
 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now