Jun 11, 2012 at 7:38 PM
Edited Jun 11, 2012 at 7:40 PM
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.
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.