开发者

ftp process is not working properly

开发者 https://www.devze.com 2023-01-19 19:15 出处:网络
I have a ssis package that does the following copies a file from an ftp to a folder. overwrite if it exists

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

精彩评论

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