July 25, 2016 at 11:57 am
My SSIS package fails using Sql Server Agent Job. When i execute the package manually from the Sql server MSDB package store, it runs fine but when i try to schedule it with job it is showing this error.
" component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. 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: 10:47:02 AM Finished: 10:47:09 AM Elapsed: 6.141 seconds. The package execution failed. The step failed."
And the proxy account i'm using to run this job does not have any credentials attached to it, how important is to do that
July 25, 2016 at 12:02 pm
uzn2010 (7/25/2016)
My SSIS package fails using Sql Server Agent Job. When i execute the package manually from the Sql server MSDB package store, it runs fine but when i try to schedule it with job it is showing this error." component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. 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: 10:47:02 AM Finished: 10:47:09 AM Elapsed: 6.141 seconds. The package execution failed. The step failed."
And the proxy account i'm using to run this job does not have any credentials attached to it, how important is to do that
This bit
There may be error messages posted before this with more information about the failure.
Is usually true – ie, there are probably other error messages which will contain more-specific details which may be of assistance. So I suggest you start there.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
July 25, 2016 at 12:12 pm
Thanks for the reply, here is the detailed error
Executed as user: nt\svc_prd_div17. ...2500.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 1:57:12 PM Error: 2016-07-25 13:57:16.48 Code: 0x00000000 Source: rt9247 SharePoint List Destination Description: Error on row ID="1": 0x80070005 - Unspecified Error - Check SharePoint Server Logs if possible. End Error Error: 2016-07-25 13:57:16.53 Code: 0xC0047062 Source: rt9247 SharePoint List Destination [20] Description: Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.PipelineProcessException: Errors detected in this component - see SSIS Errors at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket) End Error Error: 2016-07-25 13:57:16.53 Code: 0xC0047022 Source: rt9247 SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "SharePoint List Destination" (20) failed with error code 0x80131500 while processing input "Component Input" (29). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2016-07-25 13:57:16.54 Code: 0x00000000 Source: DeleteSharePointList SharePoint List Destination Description: Error on row ID="1": 0x80070005 - Unspecified Error - Check SharePoint Server Logs if possible. (SP ID=3651) End Error Error: 2016-07-25 13:57:16.54 Code: 0xC0047062 Source: DeleteSharePointList SharePoint List Destination [15] Description: Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.PipelineProcessException: Errors detected in this component - see SSIS Errors at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket) End Error Error: 2016-07-25 13:57:16.54 Code: 0xC0047022 Source: DeleteSharePointList SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "SharePoint List Destination" (15) failed with error code 0x80131500 while processing input "Component Input" (24). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2016-07-25 13:57:16.56 Code: 0x00000000 Source: rt9237 SharePoint List Destination Description: Error on row ID="1": 0x80070005 - Unspecified Error - Check SharePoint Server Logs if possible. End Error Error: 2016-07-25 13:57:16.56 Code: 0xC0047062 Source: rt9237 SharePoint List Destination [27] Description: Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.PipelineProcessException: Errors detected in this component - see SSIS Errors at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket) End Error Error: 2016-07-25 13:57:16.56 Code: 0xC0047022 Source: rt9237 SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCE... The package execution fa... The step failed.
July 25, 2016 at 1:39 pm
OK, that's (clearly) a SharePoint-related error.
I have not used the SharePoint destination, so I cannot offer much help.
Did you have to set up any SharePoint-related permissions in order to get things to work while logged in as you (ie, when using VS locally)? If so, you'll need to do the same for the SQL Agent user.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
July 25, 2016 at 1:52 pm
Yes, the proxy account was missing write access to SharePoint and after granting the access it worked 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply