SQLSrvIntegrationSrv Work Item Rss Feed

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

kevinidzi — Fri, 20 Nov 2009 04:26:00 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: Svcutil converts Linq.Xelement types to XML.XmlElement in the proxy class [10924]

kevinidzi — Fri, 20 Nov 2009 04:24:51 GMT

I am having a issue with svcutil. I am having a WCF service with Xelement type to carry data from client to the service (request objects). When i create a proxy class using svcutil, for the client (simple C# windows app) to consume every Linq.XElement type is converted to XML.XmlElement. Now the client will not compile as it expects Linq.XElement

The suggested solution to this issue (Find and replace XML.XmlElement ) is the only way.? it works fine, but its a pain, esp in the development phase when the webservice keeps changing a lot, and proxy needs to be generated often. Whats the catch here any ways.? Why it should do this Xelement inherits ixmlserializable so it should work fine..

Can anyone help me here..

Cheers
Om

Created Issue: Does SSIS Sharepoint adapter work with a Contacts List as a Target? [10969]

preachuk — Thu, 19 Nov 2009 21:11:09 GMT

When I try to use a Contacts List as a target, the adapter appears to work but the [Last Name] Sharepoint field field is not mappable. It does not appear in the Output column list. I noticed in Sharepoint that the column is defined as a required field and that it is of type 'Item' rather than 'Column'.

Can Contacts lists be used with this SSIS adapter?

The reason I ask is that we are have been told that within Sharepoint only Contact Lists can be synchronized with Outlook (and that Custom Links CANNOT be synched to Outlook). We are triyng to build Master Contact lists from external SQL Server DB sources that can be sent to Outlook.

Thanks!
Bill.

Created Issue: Svcutil converts Linq.Xelement types to XML.XmlElement in the proxy class [10924]

omapte — Wed, 11 Nov 2009 16:03:04 GMT

Commented Issue: Compiling the sample [8568]

omapte — Wed, 11 Nov 2009 15:57:45 GMT

Hi,

It's more of a question than an issue (although it is an issue for me!).
The sample compiles fine if I do not touch service references. If I update even one of them, all references to System.Xml.Linq.XElement are replaced with references to System.Xml.XmlElement. So my Visual Studio (2008, with the latest service pack) does not for some reason generate service stubs that work with LINQ.
I tried to generate the proxy classes on command line by using svcutil with targetClientVersion:Version35 switch - does not make any difference.

Your auto-generated file was created by a tool with "Runtime Version:2.0.50727.3031". Mine is "2.0.50727.3053".

So the question is - how to generate a web service reference so the proxy class uses LINQ types?

Many thanks
Mike

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

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.

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.

Commented Issue: Cannot use Sharepoint Destination [10753]

kevinidzi — Tue, 13 Oct 2009 06:54:06 GMT

Interesting. The only time I have seen that is when there is no line connecting to the destination component. In your case, you have a source connected to the destination, and when you click on the destination, it gives you that error and does not have any mapped?

Created Issue: Cannot use Sharepoint Destination [10753]

ItsInTheData — Mon, 12 Oct 2009 21:54:19 GMT

Created Issue: Issue with SharePoint List Source and numeric value (float) [10734]

lolomoss — Wed, 07 Oct 2009 14:36:52 GMT

Hi,
I try to use "SharePoint list Source" adapter with SSIS on SQL Server 2008 SP1 and I have this error message :
[SharePoint List Source [1]] Erreur : « System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Double.Parse(String s, NumberStyles style, NumberFormatInfo info)
at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket) »

I seek the problem on Sharepoint field with decimal value like currency or float type.

Can you help me please.

Thanks

Laurent

Commented Issue: Error for a scheduled job - SharePoint list adapters [10397]

kevinidzi — Tue, 29 Sep 2009 05:20:44 GMT

I have implemented a SSIS 2005 pkg that uses SharePoint List adapters.
I have created a job to call this pkg. The owner of the job is a SQL login. With this account I can access to the SQL db.
I have also create a proxy account associating a Windows account present in my SharePoint site.
From some days (before not), I have this error when the job is executed:
Error at ...: System.ServiceModel.Security.MessageSecurityException: The HTTP request is unauthorized with client authentication scheme 'Ntlm'. The authentication header received from the server was 'NTLM'. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized...
Any helps for me, please? It is an urgent issue. Many thanks
Comments: ** Comment from web user: kevinidzi **

This is one that has been in the discussion a few times. It is most likely not related to your credentials, but the way you're getting at the site. If the SP site has a host header, try replacing the host header in your URL with the Server name + port and try again. Sorry i'm a bit late if this was urgent.

Created Issue: Error for a scheduled job - SharePoint list adapters

pscorca — Wed, 05 Aug 2009 15:49:11 GMT

Commented Issue: SSIS Sharepoint Dest. - Trouble Inserting Datetime (DT_DBTIMESTAMP) into a Sharepoint List

kevinidzi — Sat, 27 Jun 2009 18:02:23 GMT

If I Insert Datetime Values (DT_DBTIMESTAMP in SSIS) into a Sharepoint List using the SSIS 2005 Sharepoint Destination, the time part is always set to 23:30. Example: 15.05.2009 09:15 --> 15.05.2009 23:30.

If I try the same piping the Data through an Access Database (I know thats dirty!) into my Sharepoint list, everything is fine.
Comments: ** Comment from web user: kevinidzi **

Thanks for the workaround, maybe i'll work out something in the future so that it isn't necessary, the next time updates are made. Thanks!

Commented Issue: SSIS Sharepoint Dest. - Trouble Inserting Datetime (DT_DBTIMESTAMP) into a Sharepoint List

SvenMe — Sat, 27 Jun 2009 07:27:37 GMT

The workaround proposed by RockClimberJack works just fine. The whole thing isn't logical, but it works. Many thanks.