I have a ssis package that does the following
- copies a file from an ftp to a folder. overwrite if it exists
- copy data to sql db
- 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
- ftp file is NOT copied
- 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.
精彩评论