This is a newsgroup for discussing COZYROC family of products. Enjoy.
Updated: 16 hours 9 min ago
Hi, Use COZYROC Salesforce Destination component to update records.
Hi Brett, When you test and develop from Visual Studio (BIDS), no license key is required. A license key is required if you want to schedule and execute packages under SQL Job agent.
We recently had a client deliverable that involved pulling data from a MySQL instance. This also required us to open an SSH tunnel in order to establish the connection. This post is to help anyone else out that experiences a similar scenario and gets stuck the way we did. We have been COZYROC
Hi, COZYROC's Salesforce adapters depend on the .NET framework for support of the HTTPS protocol. SQL Server 2008 R2 is based on .NET 3.5 framework which doesn't support TLS 1.1 or 1.2 by default. Microsoft provides patch for .NET 3.5.1 which claims it could enable support for the missing
Right-click on the SharePoint connection manager and select Properties. Set RetainSameConnection=False . Try now to execute your package.
Hello, If you are getting this error, the input file is most probably not a GZip file.
Hi Leigh-Anne, Starting from SQL Server 2012 there is no longer need to manually include third-party tasks and components. The third-party components will automatically appear in the custom 'SSIS Toolbox'. Check there.
Hi Will, The error message means your SQL Server server is not properly licensed.
Hi John, Can you please let me know the issue. I am facing the same issue while pulling data from salesforce. Regards, Prabhat Yadav
I don't have experience with Dynamics CRM server administration. I would recommend you post a question in Dynamics CRM forum.
You have to upgrade to SQL Server 2012 and above. There is no other option available at this time.
I managed to get this working in the end. I tried several options changing between 32bit and 64 bit run times, changing between 32bit and 64 bit MySQL ODBC drivers for the DSN, changing the MSSQL source between OLE and ADO. There was mixed results, in some cases it would process more or less
Hello, I am not able to use the CozyRoc components (SSIS + 1.6 SR- 4 ) in my ssis package with Visual Studio 2015 and sql server 2012. When I try to insert both the Salesforces Destination or Source component, the Data Flow Editor complains with the following error: Object reference not set to
Hi Abdelhafid, I would recommend using the latest official SSIS+ 1.6 SR-4 version.
Hi Phil, Support for SQL Server 2016 will be included in the next major SSIS+ 1.7 version of the library. The public beta will open soon.
Hi Scott, SSIS+ 1.7 will be released this year.
You cannot use count attribute in your FetchXML statement. The count attribute is setup by the Dynamics CRM Source component and used for processing the data in batches. You have to come up with different algorithm to limit the data you want to retrieve.