July 28, 2010 at 12:05 pm
Hi Guys,
I have an SSIS package that uses the "DFS 2008" data flow source. I can run the package just fine from VS9, and from Management Studio (from MSDB). However, when I create a job to run the package under a proxy account I get this error message:
Executed as user: GLOBAL\ssis_proxy. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:38:16 PM Error: 2010-07-28 13:38:18.48 Code: 0xC004706B Source: Data Flow Task SSIS.Pipeline Description: "component "Split Crane File" (1)" failed validation and returned validation status "VS_ISCORRUPT". End Error Error: 2010-07-28 13:38:18.51 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-07-28 13:38:18.51 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:38:16 PM Finished: 1:38:18 PM Elapsed: 1.969 seconds. The package execution failed. The step failed.
If I run the job under my login, it works just fine. If I run it under the SQL Server Agent Service Account, I get a different error message due to the agent account not having access to the file share - I expected this.
It seems as thought the ssis_proxy account has an issue with the custom "DFS 2008" data flow source.
Any ideas?
June 11, 2012 at 1:50 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?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply