SQL Agent

Jun 11, 2012 at 7:38 PM
Edited Jun 11, 2012 at 7:40 PM

Hello.

I try to schedule SSIS package using DF2008 in SQL Agent but i have problems. When i am logged into server the job finish with success. When i am logged out it fails. I tried using proxies accounts but the same problem as someone described here: http://www.sqlservercentral.com/Forums/Topic960262-391-1.aspx

I can start for example SQL Agent on user account then run Job with DFS2008 on it and it will work. It isn't good idea. I can't do like that.

Conclusion:

If user4 on LAP4 has started any process (for example SQL Agent started on user4 or Reporting Services) the job with DFS2008 will be succeed.

If user4 on LAP4 hasn't got started any process the job will fail.

 

How can i resolve that problem? Any idea?

Information from SQL Agent:

Executed as user: LAP2\user4. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  20:39:45  Error: 2012-06-11 20:39:46.55     Code: 0xC004706B     Source: DFS 2008 File Task SSIS.Pipeline     Description: "component "DFS 2008" (1)" failed validation and returned validation status "VS_ISCORRUPT".  End Error  Error: 2012-06-11 20:39:46.55     Code: 0xC004700C     Source: DFS 2008 File Task SSIS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2012-06-11 20:39:46.56     Code: 0xC0024107     Source: DFS 2008 File Task      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  20:39:45  Finished: 20:39:46  Elapsed:  1.264 seconds.  The package execution failed.  The step failed.