Hi guys ,
I have defined one package from SSIS which performs following tasks:
1. Launch FTP files from FTP server
2. Extract those files, which are basically (.gz) zipped files and load extracted files to another folder.
I am using FTP task for task 1 and Execute process task for task 2.
No when I run this package from my SSIS then ot runs very fine and produces results as expected BUT when I schedule them from Job scheduler in SSMS then this package runs forever. I am not sure what is the problem but the package does not end executing itself.
I am not sure if I have access problems. I have tried running packages from different locations but did not earn me any results.