News

updated NetSuite Destination

Site - 19 hours 8 min ago
Sat, 08/27/2016 - 12:20

updated NetSuite Destination

Re: cozyroc salesforce connection password via SSIS Project parameters

Forum - 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

Forum - 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: DFT+ not working in Visual Studio 2015

Forum - Wed, 09/28/2016 - 12:12
Hi Christina, DFT+ from SSIS+ 1.6 version is not working properly under VS 2015 because of an issue which Microsoft has yet to resolve. If you want to develop for SQL 2014, I would recommend using VS 2012 or 2013 instead.
Categories: News

Re: Update Salesforce records

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

Re: Unable to retrieve digital product id

Forum - 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

Forum - 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

Forum - 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

Forum - 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"

Forum - 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: SSIS+ on SQL Server 2016 error

Forum - Sat, 07/16/2016 - 07:34
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.
Categories: News

Re: Unable to retrieve digital product ID.

Forum - 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!

Forum - 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

Forum - 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

Re: Salesforce connection TLS 1.0 to TLS 1.1

Forum - Wed, 07/06/2016 - 01:09
You have to upgrade to SQL Server 2012 and above. There is no other option available at this time.
Categories: News

Released COZYROC SSIS+ 1.7 Beta 1

Blog - Fri, 07/01/2016 - 15:45

COZYROC is delighted to announce the availability of a beta release of SSIS+ 1.7. This release includes support for SQL Server 2016 as well as several new components that you've been asking for. We're especially excited about our REST components because they are so versatile. Initially, you can use them for accessing eight different REST services. Keep the requests coming so we know what services are most important to you! Here's a list of the new features in SSIS+ 1.7:

Click here to download the beta release of COZYROC SSIS+ 1.7 library

If you have any questions or comments, please let us know. We're here for you.

Regards,
The COZYROC Team

Categories: News

Re: Issues with ODBC Destination MySQL (AWS)

Forum - Thu, 06/30/2016 - 04:44
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
Categories: News

UI Component compatibility with VS2015 and Sql Server 2012

Forum - Fri, 06/24/2016 - 13:28
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
Categories: News

Re: Migration SSIS CozyRoc server 1.6 (Sql Server 2008 R2) to SSIS SQL Server 2012

Forum - Thu, 06/16/2016 - 08:15
Hi Abdelhafid, I would recommend using the latest official SSIS+ 1.6 SR-4 version.
Categories: News

Re: I am getting an SSH error when I am trying to import a package into Visual Studio

Forum - Mon, 06/13/2016 - 20:14
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.
Categories: News
Syndicate content