Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-04-30 : 04:02:20
|
| I have deployed my ssis package to Production.It works fine in Dev but the following error occurs when it runs in Prod.Can you see from the error below how the issue can be solved polease?04/30/2012 08:50:24,Downloadxxx,Error,0,servername,Downloadxxx,(Job outcome),,The job failed. The Job was invoked by User companyname\Administrator. The last step to run was step 1 (Step_).,00:00:01,0,0,,,,004/30/2012 08:50:24,Downloadxxx,Error,1,servername,Downloadxxx,Step_,,Executed as user: companyname\SQLAgent. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 08:50:24 Error: 2012-04-30 08:50:24.97 Code: 0xC0047038 Source: Import Data SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Flat File Source" (1) returned error code 0x80040E21. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component<c/> but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 08:50:24 Finished: 08:50:24 Elapsed: 0.953 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-30 : 10:33:49
|
| is there some other error messages also posted? Also whats does flat file contain currently?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
|
|
job fails when executing ssis package