First deployment! Using SPCRED connection manager not valid on target server.

[Dom Cotton]

Hi,

 

I am trying to perform my first deployment to a live server using Cozyroc components.  I am reading data from a sharepoint list source, then updating a date against the item using the sharepoint list destination.  In my development environment everything is working fine.  I am using the package deployment method in visual studio, and am attempting to execute "dtexec" on my target server.  I have many other dtsx files executing on this server so know that environment is ok.  I have also checked my cozyroc license application and its all good.

 

 

Below is the output when i try and run it.  Can anybody help me understand why the SPCRED isn't being recognised? 

 

 

----- start code -----

 

E:\Applications\APP053>dtexec /f monitor.dtsx
Microsoft (R) SQL Server Execute Package Utility
Version 11.0.2100.60 for 64-bit
Copyright (C) Microsoft Corporation. All rights reserved.

Started:  10:18:25
Error: 2014-01-17 10:18:26.10
   Code: 0xC0016016
   Source: Monitor
   Description: Failed to decrypt protected XML node "ServerPassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.

End Error
Error: 2014-01-17 10:18:26.38
   Code: 0xC0014005
   Source: Monitor
   Description: The connection type "SPCRED" specified for connection manager "SharePoint Credential" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
End Error
Error: 2014-01-17 10:18:26.38
   Code: 0xC0010018
   Source: Monitor
   Description: Error loading value "<DTS:ConnectionManagers xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:ConnectionManager DTS:refId="Package.ConnectionManagers[SharePoint Connection Manager 1]" DTS:CreationName="SHAREPOINT" DTS:DTSID="{435379C8-D465-49DC-98E3-93242B62E091}" DTS:ObjectNa" from node "DTS:Connection Managers".
End Error
Could not load package "monitor.dtsx" because of error 0xC0010014.
Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when Package::LoadFromXML fails.
Source: Monitor
Started:  10:18:25
Finished: 10:18:26
Elapsed:  0.531 seconds

E:\Applications\APP053>

 

----- end code -----

 

 

Many thanks in advance.

Dominic

[Ivan Peev]

Hi Dominic,

SPCRED is not a COZYROC connection manager. I think this is part of the Microsoft samples package. You have to modify your package to use COZYROC's components.

[Whitley, Eric]

Completely off the wall question. Has anyone attempted to inspect total bytes transferred from a source DFT (or connection?) for a given package execution?

Scenario: you're using SSIS to consume data from a server. How much data do you transfer across the network for a given object/result set for a package execution?

[Ivan Peev]

Hi Eric,

It is hard to tell because the bytes transferred are dependent on the specific connection and provider in use. In my opinion you have to use independent of SSIS technology to track the network traffic. Some kind of application which allows you to track specific application for a specific time period.

[Whitley, Eric]

Thank you for the prompt response J  That was our working assumption as well, but I figured I’d ask the Cozyroc engineering masters in case we missed some magical internal instrumentation.

 

Thank you,

Eric

--
You received this message because you are subscribed to the Google Groups "COZYROC" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cozyroc+u...@googlegroups.com.
To post to this group, send email to coz...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cozyroc/ab2da867-5197-4bcc-bd90-f268523cb12a%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.