|
arkiboys
Flowing Fount of Yak Knowledge
1346 Posts |
 Posted - 04/30/2012 : 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,,,,0
04/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 |
|
job fails when executing ssis package
