(SQL Server2005SP3) I open SSIS|Logging in my project and check logging for every event. I use SSIS Log provider for text select OnError and OnTaskFail events and a connection. The connection creates a file on my desktop named SSIS Logging. I deploy the SSIS package. I have a SQL Server Agent job that runs the package. Inside of Agent I also turn on SSIS log provider for Text files and use the same connection string. Run the package and it fails.....no log file on my desktop. What am I doing wrong???

What is the error? It must be that the file is locked.Arthur My Blog

Execution of job "DataLoad" failed. See the history log for details.

Please get the info from that log.Arthur My Blog

There is no history log. SQL Agent Error logs have nothing. SQL Server Management logs have nothing. I don't know where a "history log" can be found.

Please run this package using DTSExec w/o the SQL Agent and tell us if it worked or not.Arthur My Blog

It works when I run it from SMS. I had been tracking a precompiled script bug when logging stopped working.

It is not the same when you run it using DTExec. What is the relation to the precompiled script?Arthur My Blog

Since I can't get logging to work anymore I don't know if that is the problem anymore.

This is very simple...Since when you are executing the package in design mode it is executing under your crediential and you have given desktop path. But whn you run the package through SQL Agent job it runs under Service account and Service account don't have any profile in your computer, that's why it is not able tocreate any file on the desktop. And also it depends upon the permission to the service account. Try by changing the path other than desktop. Might be like C:\ or D:\

Thank you....that's all it took!!!!