application not downloading files from FTP when app publish

Rakesh Surve

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rakesh Surve9y ago
Hello Rajkiran,
My application work fine. It follows all the process step by step. But my ssis package and stored procedures not running from published iis. When i run my application using visual studio it perform all the task like download data, import data to remote database. but it fails while running from IIS or published app url.
NOTE: Its not throwing any error to send screen shot.
Rajkiran Swain9y ago
What is the error please ?

Could you please prvide the screenshot of the error .