Link to home
Start Free TrialLog in
Avatar of Favorable
FavorableFlag for United States of America

asked on

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.
SOLUTION
Avatar of SThaya
SThaya
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Alpesh Patel
Alpesh Patel
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial