I have a package that imports data from Oracle server into SQL Server. I use XML config file for SSIS job schedule and it runs fine on the Test box now i deployed the package on Prod server as a file system and schedule it as a Job but when i run
the job it continously running and never get finish the job or stop. I manually stop the package and cannot find any error and could not find any clue . If i run the package on prod through SSIS manually it works fine. Any suggestion would be appreciated.
View Complete Post