开发者

ftp process is not working properly

I have a ssis package that does the following

  1. copies a file from an ftp to a folder. overwrite if it exists
  2. copy data to sql db
  3. delete file from ftp

i have send email task if the ftp fails.

Scheduled this ssis in jobs. I created a 2MB test file and ran the job. Works perfect!

now tried with a 500 MB file in the ftp. Works pefect when i run it from the IDE.

When i execute the job

  1. ftp file is NOT copied
  2. data is copied from existing file

no errors returned. package execut开发者_JAVA技巧ed successfully. What's going wrong here?


Could be a silent timeout or such.

Have you considered zipping/unzipping to reduce the actual FTP duration and size?


the issue was

it was a directory permission issue. Sql server doesnot throw any error message when the ftp task does not copy.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜