Hi, I have created a SQL Agent job in SQL Server 2008 to execute a basic test SSIS package. I am executing the package from a shared file system. All the package is doing is running a dummy Script Task. I wanted to test logging to a text file for some events such as PreExecute, PostExecute and OnError. SQLAgent is running as a windows active directory account not the Local System or Network Service account. SQLAgent seems to suggest that the Package runs successfully. However, the log text file is not generated to the file share specified. There are no errors generated or displayed in the History in SQLAgent. We tried changing the log location to somewhere where the SQLAgent service account did not have permission to write to and we do get a 'permission denied' type of error. Therefore, I am not sure what to check next given that no obvious errors are generated. Any suggestions are appreciated. MrPedsDatabase and Application Developer

I have seen this when the "Run as" account used in the SQL Agent Job Step does not have access to the directory or share. The package ran with no error however the logging file was not created.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: MrWharty.wordpress.com

Hello, When you run package in BIDS , does it create log file for you? If it creates log file in BIDS and not by using SQL Server agent then could be permission issue. Thankshttp://sqlage.blogspot.com/

I think you could try to log those events to SQL Server instead of file system to debug those issues. Then when package is executed, you could turn on sql profiler to check what happens during logging.