Microsoft SQL Server Community Samples: Integration Services

Commented Issue: Unspecified error while using SharePoint Destination Adapter [10828]

cs51tg — Thu, 05 Nov 2009 10:37:01 GMT

I am getting UnSpecified Error while SharePoint Adapter is trying to insert items in the list.
How do I check what is the error?
Comments: ** Comment from web user: cs51tg **

Hi,

We too are getting a similar errors when trying to insert or update items in a list. The process to update items in SharePoint has been running for several months now without error. Please advise how to further diagnose the problem. SSIS error output is below:

Beginning of package execution.
Error on row ID="1": 0x80070005 - Unspecified Error - Check SharePoint Server Logs if possible.
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(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)
SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "New Data List" (15515) failed with error code 0x80131500. 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.
SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0x80131500. There may be error messages posted before this with more information on why the thread has exited.
End of package execution.

Not much to go on, I appreciate, but where else should we be looking.

Thanks

New Post: EzApi for sql server 2005

jibin — Wed, 04 Nov 2009 09:07:57 GMT

Dear all,

Please tell me how to convert the eZapi[c# code] from sql server 2008 to sql server 2005.

thanks,

Jibin

Reviewed: SharePoint List Source and Destination (Nov 03, 2009)

salemboot — Tue, 03 Nov 2009 22:01:52 GMT

Rated 5 Stars (out of 5) - Deffinately the skeleton key you need

New Post: No Input columns

thomastx05 — Sat, 31 Oct 2009 21:34:45 GMT

Ok so aparently I just neded to push refresh on the column mapping page. all is well.

New Post: No Input columns

thomastx05 — Sat, 31 Oct 2009 19:00:18 GMT

I bed that I seam to be the only one with the problem, but when I creat a sharepoint list source it connects fine but it show I have no columns for mapping. There are several columns however in the list they just do not show up in ssis.

New Post: SSIS Copy files form and to SharePoint document library

mweaver59 — Fri, 30 Oct 2009 11:55:42 GMT

I am trying to automate a files copy rename from source SharePoint Document Library to a Destination SharePoint Document Library with SSIS

There will be about six files posted once a week to source folder with the same name every week and will overwrite the file in the folder.

I need to copy and rename the files to the SharePoint Document Library archive folder before they will be overwritten and add the file date to the file name

The reason fro SSIS is because that is all that I am aloud. I just have bids 2005.

New Post: SSIS / SharePoint Source and SQL Agent issue

Larcher — Tue, 27 Oct 2009 16:53:14 GMT

Well ...i found my problem (after 4 hours spent on it !!) i put the SQL Agent account admin of SharePoint, but it seems that i need to declare this account to the SharePoint child List too

New Post: SSIS / SharePoint Source and SQL Agent issue

Larcher — Tue, 27 Oct 2009 16:47:40 GMT

I built a package on SQL 2005 with the SharePoint source component.

This package works on Business Intelligence Studio, and with SSIS (ran manually)

I put this package on a Job on SQL Agent : i got this message when i ran the job :

Executed as user: HAYWARD\SQL. ...ersion 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 17:34:47 Error: 2009-10-27 17:34:51.06 Code: 0xC0047062 Source: TRANSFERT SharePoint List Source [1] Description: Microsoft.Samples.SqlServer.SSIS.SharePointUtility.SharePointUnhandledException: Unspecified SharePoint Error. A possible reason might be you are trying to retrieve too many items at a time (Batch size) ---> System.ServiceModel.FaultException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Server stack trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean on... Process Exit Code 1. The step failed.

I dont use the same Account for package designing and SQL Agent Account, anyway, both of them are setup on my sharepoint website.

Can you help me ?

regards

Thomas

New Post: Update the SQL table whne a new item is added in a sharepoint list

scvinod — Tue, 27 Oct 2009 05:14:43 GMT

Hi kevinidzi,

Thanks for your reply. Well, that is what I'm looking for.

New Post: Update the SQL table whne a new item is added in a sharepoint list

kevinidzi — Tue, 27 Oct 2009 04:44:54 GMT

With this component, you cannot update when a new item is added. But you could schedule a job to run every X minutes and check for any new items since the last time, and update the new items as appropriate. If that might be a scenario you are looking for, then we can help you out.

Created Issue: Unspecified error while using SharePoint Destination Adapter [10828]

truptigondaliya — Sun, 25 Oct 2009 15:02:11 GMT

I am getting UnSpecified Error while SharePoint Adapter is trying to insert items in the list.
How do I check what is the error?

Commented Issue: Cannot use Sharepoint Destination [10753]

kevinidzi — Wed, 21 Oct 2009 19:14:38 GMT

I have an odd issue which doesn't seem to exist anywhere else on these or other forums.

I can use the Sharepoint Source component easily. Very beautiful component. I would like the Destination to operate too.

Every time I try to use the Destination, from various accounts and systems and targeting various sites, I cannot do anything. I create the options just like the source, however this leaves the component at a failure error of "There are no columns mapped to the output columns." In fact, there are no output columns, and I cannot create any since the component will not allow me to.

I have the exact same configuation screen just like figure 12 in this "instruction" url: http://msdn.microsoft.com/en-us/library/dd365137.aspx

Please can someone tell me if I have a unique bug, and how to fix it? I am using SQL Server 2008 on a Windows 64 bit box. I have installed the Sharepoint Components to the (x86) part of the server (the .msi auto-picked that and I left it alone). I have the BIDS solution running in 32-bit mode due to an existing Excel source in the same package for testing purposes. I'm obviously thinking any number of things in that could be the problem, but can anyone help verify?

Thanks!
Comments: ** Comment from web user: kevinidzi **

Try hitting the "Refresh" button and see if those columns snap in place, when this happens again. I always hit that just to be safe after connecting things together if I see one box, not two with the line connecting together in the destination component. That might be the missing piece.

It's mainly just due to the way things are added, but SSIS provides that refresh button to let you fix it up.

New Post: Update the SQL table whne a new item is added in a sharepoint list

scvinod — Wed, 14 Oct 2009 18:33:31 GMT

Hi All,

I have created a Integration Service Package with a SPList as the source and a SQL Table as the destination. I want the SQL Table to get updated when a new Item is added in to the SPList. I'm new to this.Can anyone please help me out.Thank you.

Reviewed: SharePoint List Source and Destination (Oct 13, 2009)

robsch — Tue, 13 Oct 2009 21:55:59 GMT

Rated 5 Stars (out of 5) - Works really well. It helped me see the facility of SharePoint lists in a broader scope, and now we're using this capability for light MDM.

Commented Issue: Cannot use Sharepoint Destination [10753]

kevinidzi — Tue, 13 Oct 2009 19:48:53 GMT

You’re very welcome. I have not run into the issues you are describing, but I’ll try to repro it in a few days. I'd like to clean up some issues before the big SP Conference next week.

I'm glad you got it to work.

Commented Issue: Cannot use Sharepoint Destination [10753]

ItsInTheData — Tue, 13 Oct 2009 18:44:22 GMT

I have found a workaround. Thanks for the ideas, it did sort of lead me to the workaround:

If I create any Source first and link to the Destination before editing the Destination, then the Destination always fails like this for me.

However, if I first create the Destination and edit it without joining a source then the Destination columns appear just with errors for no input. Now if I click "OK" and join the Source and then re-edit the Destination then I am able to map correctly.

Not sure why it works like that for me, we must have some odd patch or other installed software causing this. But at least I have a workaround.

By the way, now that I can map ... this component ROCKS!!! Very useful! Thanks for building it!

Commented Issue: Cannot use Sharepoint Destination [10753]

ItsInTheData — Tue, 13 Oct 2009 17:09:46 GMT

I have already used the same list as a source to confirm that I can read it correctly. Also, I have used the same account to connect to Sharepoint to manipulate the list by hand so I know I can edit it. I had also tried to use other sources just in case the "loop" situation was the problem, but no source is working for this destination.

Commented Issue: Cannot use Sharepoint Destination [10753]

kevinidzi — Tue, 13 Oct 2009 16:37:44 GMT

All I can think of is to double-check the destination SP settings. Try creating a fresh list, perhaps it does not have access to it or something. There should be errors in that case, but maybe something is amiss in the target list.

If it cannot find the columns, then I'm guessing that it cannot read the list in some way. If you can use the source, could you try hooking up the same list as for source -> target (so that it is like a loop). See if that works, and if it does, then we can dig into your particular sharepoint destination.

Commented Issue: Cannot use Sharepoint Destination [10753]

ItsInTheData — Tue, 13 Oct 2009 15:49:41 GMT

Correct. I have the simplest of mappings. A Source, a Lookup, and a Destination and they are joined. The columns from the input connection are showing up automatically, but I do still have this issue.

Also, I have confirmed that 64 bit is not the problem. My laptop is 32 bit, and I repeated the install on my laptop. I created a new Visual Studio SSIS package with just a Source and a Destination both from Sharepoint. I did not attach anything to the 64 bit server or database just in case that system was the cause. Still I have this error when everything is isolated to a "normal" 32 bit system.

Does anyone have any other ideas? I'm stuck.

New Post: Update SP List using Sharepoint Destination List

Thehammer848 — Tue, 13 Oct 2009 09:51:37 GMT

Kevin

Thanks for responses on this issue. I think I have discovered the problem. The list that I am trying to update has a connection back to an application database and is synchronized by a process supplied by the vendor. I created a duplicate list that was not set up to be synchronized and I was able to update 1900+ records in a few seconds.

The way the synchronization works is when sharepoint is updated it immediately tries to update the SQL database with the new information. Before it tries to update the database it has to check the application security to ensure the person doing the update has permissions in the application to update that data. I think the added processing of trying to update the application database and having to check the security is adding the additional time, and processing, so that the update is timing out.

I am going to check with the vendor about this and see if there’s anything that we can.

Again, thanks for your help on this matter.

Jon

This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation.

This email has been scanned and certified safe by SpammerTrap(r)