Connection Type Error when scheduling job to import contacts using cozyroc CRM destination

[Mohammed Nawaz]

Hi,
When i execute the package from with in BIDS it runs fine. But if i
schedule it the package to run on the server. I get the connection
type errror. Below is the error i get. Also here is the datasource
connection string it's creating when i schedule the package. Please
Help.

Here is the commandline connection string in schedule job:
/SQL "\CRM_CampaignResponse_Import" /SERVER "txallendb13\test" /
CONNECTION "Dynamics CRM Connection
Manager";"\"DeploymentType=Premise;ServerHost=http://
crmtestnew.stei.com;ServerUser=mnawaz;OrganizationName=StewartEnterprisesTest;ServerTimeout=100;RetainSameConnection=True;Compression=False;ConnectionSharing=False;LiveUrl=crm.dynamics.com;ProxyHost=;ProxyPort=0;ProxyUser=;
\"" /X86 /CHECKPOINTING OFF /REPORTING E

Here is the error i am getting when trying to connect and execute the
package.
0.0.4000.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All
rights reserved. Started: 3:45:00 PM Error: 2012-07-09
15:45:00.67 Code: 0xC0014005 Source: Description: The
connection type "DYNAMICS-CRM" specified for connection manager
"Dynamics CRM Connection Manager" 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:
2012-07-09 15:45:00.67 Code: 0xC0010018 Source:
Description: Error loading value "<DTS:ConnectionManager
xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:Property
DTS:Name="DelayValidation">0</DTS:Property> <DTS:Property
DTS:Name="ObjectName">Dynamics CRM Connection Manager</DTS:Property>
<DTS:Property DTS:Name="DTSID">{D9D41074-0D8" from node
"DTS:ConnectionManager". End Error Could not load package
"\CRM_CampaignResponse_Import" because of error 0xC0010014.
Description: 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. Source: Started: 3:45:00 PM Finished: 3:45:00 PM
Elapsed: 0.39 seconds. The package could not be loaded. The step
failed

[Ivan Peev]

Mohammed,

Did you install COZYROC SSIS+ library on your server? If yes, did you use the 64bit installer? From the error below it looks like COZYROC Dynamics CRM manager is not found.

Ivan