Syndicate content
This is a newsgroup for discussing COZYROC family of products. Enjoy.
Updated: 13 hours 2 min ago

Re: Failure while using Salesforce Source Task

Tue, 10/25/2016 - 16:44
Hi, Check your expression used to setup the SOQL statement. Most probably the issue is there.
Categories: News

Re: Exchange connector issues

Mon, 10/24/2016 - 17:56
Marcel, You have to provide both read/write explicit permissions to the License.dat file for the user account you use under SQL Job agent. All of this and more is explained on the license instructions page here.
Categories: News

Re: Data Flow Task Plus SPARSE Column Support

Tue, 10/18/2016 - 21:17
Hi Dylan, Based on your description I would say the issue is not COZYROC DFT+ but the fact SELECT * ... statement doesn't return the appropriate columns information. You have to find how you can make the database provide all columns information . Then I suspect the DFT+ will work just fine.
Categories: News

Re: DFT+ not working in Visual Studio 2015

Thu, 10/13/2016 - 17:33
Hi Nikhil, You can use VS 2010 or VS 2012 for SQL Server 2012 development.
Categories: News

Re: SSIS+ on SQL Server 2016 error

Thu, 10/13/2016 - 06:28
Hi Nikhil, Switch the solution to SQL Server 2012 or 2014 mode and you should see COZYROC's components appear in the custom SSIS Toolbox.
Categories: News

Re: Development using 1.6 Library without licence

Thu, 10/13/2016 - 06:10
Hi Nikhil, When you test and develop from Visual Studio (BIDS), no license key is required.
Categories: News

Re: Salesforce source object filter variable

Wed, 10/12/2016 - 20:36
Hi Dona, You have to setup SSIS expression to modify the ObjectFilter parameter at runtime. I would recommend you check the "Dynamic Query" demo video from the documentation page here.
Categories: News

Re: Salesforce connection TLS 1.0 to TLS 1.1

Thu, 10/06/2016 - 13:56
Hey Patrick - We're running into this issue with one of our Sandboxes and are trying to be proactive about it before Production switches to TLS 1.1. The problem we face is that our I.T. department has all of our machines heavily locked-down and we can't make any updates that require admin
Categories: News

Re: SSH Connection Manager over TLSv1.2

Wed, 10/05/2016 - 06:05
Hi Azmi, The SSH connection manager is not related to the TLS protocol. TLS applies to the FTPS connection manager.
Categories: News

Re: cozyroc salesforce connection password via SSIS Project parameters

Thu, 09/29/2016 - 14:40
Hi, I believe you should be able to use Project parameters in the Salesforce connection manager.
Categories: News

Re: CoayRoc Table Difference Update and Unchaged Pipeline Flow issue

Thu, 09/29/2016 - 08:15
Hi, Either your setup is incorrect. Or the data between the old and new input is different. If you believe that is not the case, send a complete test package and input data to COZYROC's support and we will analyze it further.
Categories: News

Re: Update Salesforce records

Tue, 09/13/2016 - 17:50
Hi, Use COZYROC Salesforce Destination component to update records.
Categories: News

Re: Unable to retrieve digital product id

Wed, 09/07/2016 - 19:46
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.
Categories: News

SSH tunnel and Port Forwarding via SSIS Script Task Plus

Thu, 08/11/2016 - 19:39
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
Categories: News

Re: Cozyroc SSIS - could not create SSL/TLS secure channel

Fri, 08/05/2016 - 06:16
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
Categories: News

Re: SharePoint Connection Manager Issue

Thu, 08/04/2016 - 06:20
Right-click on the SharePoint connection manager and select Properties. Set RetainSameConnection=False . Try now to execute your package.
Categories: News

Re: Unzipping GZ file fails with "Error GZIP header, first magic byte doesn't match"

Fri, 07/29/2016 - 15:10
Hello, If you are getting this error, the input file is most probably not a GZip file.
Categories: News

Re: Unable to retrieve digital product ID.

Sat, 07/16/2016 - 07:33
Hi Will, The error message means your SQL Server server is not properly licensed.
Categories: News

Re: SSIS Excel Source Plus - Error message "Make sure all message related files are registered!

Sat, 07/16/2016 - 07:30
Hi John, Can you please let me know the issue. I am facing the same issue while pulling data from salesforce. Regards, Prabhat Yadav
Categories: News

Re: CRM 2015 Update Failed

Tue, 07/12/2016 - 13:03
I don't have experience with Dynamics CRM server administration. I would recommend you post a question in Dynamics CRM forum.
Categories: News