I have developed one appliaction that triggers to SSIS package. In my ssis package i have implmented FTP download, extract the files, combine that files and import to database.
When i am running my application from visual studio it works fine. But when i published this applicaction on IIS and deploy that package on sql server it not working. I have already given all the credential to sql server and iis.
I amy trying to download files from ftp to local directory. But its not downloading the files.