News

updated NetSuite Destination

Site - 16 hours 54 min ago
Wed, 07/13/2016 - 01:11

updated NetSuite Destination

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

Re: SQL Server 2016 Support

Forum - Fri, 06/10/2016 - 14:56
Hi Scott, SSIS+ 1.7 will be released this year.
Categories: News

Re: CRM Source FetchXML with "count" attribute errors out

Forum - Tue, 06/07/2016 - 21:16
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.
Categories: News

Re: Insert Rows into Sfdc and return the ID/Error.

Forum - Wed, 06/01/2016 - 14:45
Hi Lee, You can redirect the error output from COZYROC's Salesforce Destination component to a standard OLE DB Command transformation component and update the rows in the source table with the information returned for the Id and Error Description.
Categories: News

Re: Receiving File error when the file does not exist in the SFTP task

Forum - Thu, 05/26/2016 - 06:06
Hi Rafiq, Please next time do not hi-jack existing unrelated discussions, but create a new discussion. Regarding your question, you can setup a failure constraint and handle the error situation as you please.
Categories: News

Re: Access to the path 'C:\Program Files(x86)\CozyRoc\SSIS\License.dat' is denied

Forum - Wed, 05/25/2016 - 11:55
yes, it wasn't enough to give the sql agent rights to the file. I gave full permissions to the file to all users and now it works.
Categories: News

Re: Salesforce Source - Refresh Generates XML Document Instance Validation Error

Forum - Wed, 05/18/2016 - 08:10
Great! Don't know what caused it, but it's an easy workaround. Last idea was the best.
Categories: News

Re: Data Flow Task Plus isn't doing anything

Forum - Wed, 05/18/2016 - 06:58
Replying to myself, to document the solution I found. I hope it will be of some help to others having the same problem. First of all: the cause of the problem is that DFTP is unable to correctly retrieve the columns from DB2 when the table name is an alias. I was dealing with aliases, so I had to
Categories: News

Re: SharePoint Update does not update field with Null.

Forum - Tue, 05/17/2016 - 15:24
Hi Dave, This behavior is by design. If you want to reset field , pass empty string as input.
Categories: News

Re: Can the EDI components be used to process varying record types in a single file?

Forum - Wed, 05/11/2016 - 09:02
Dave, "reached end of mapping model" means there is incoming input data which is not describe in the layout you have defined.
Categories: News
Syndicate content