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

UI Component compatibility with VS2015 and Sql Server 2012

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

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

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

Mon, 06/13/2016 - 06:54
Hi Michael, SSIS+ 1.6 SR-4 doesn't support SQL Server 2016. Support for SQL Server 2016 will be included in the next major 1.7 version of the SSIS+ library.
Categories: News

Re: SQL Server 2016 Support

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

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.

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

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

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

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

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.

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?

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

Re: "Excel Connection Manager 1" is not recognized as a valid connection manager type.

Tue, 05/10/2016 - 17:47
Beth, If you search for CozyRoc.SSISPlus*.dll file , you should find the file present in both "C:\Program Files (x86)" and "C:\Program Files" .
Categories: News

Re: Is it possible to create dynamic SSIS package to load data into multiple table using OLEDB to OLED

Tue, 05/10/2016 - 17:45
Manoj, What happens when you double-click or click on Edit... ?
Categories: News

Re: EDISource Configuration File Supporting Component and Sub-component Elements

Sat, 05/07/2016 - 09:42
There error message says you have a 'component' element directly inside a 'segment' element, which is not allowed. To fix the error remove the closing slash on the opening field element as highlighted below:
Categories: News

Re: Salesforce Lookup Transformation Malformed_query

Tue, 05/03/2016 - 18:52
Hi Ivan, As you probably guessed, my package protection level was set on "Don't Save Sensitive". So the SalesforceObject parameter was lost at run-time. I didn't know that the script parameters was considered sensitive. I should have known. Anyway, thx a lot for your help. Alexis
Categories: News

Re: Script Component Plus Configuring Dynamic Flow Fuzzy Lookup

Tue, 05/03/2016 - 18:51
Hi Ryan, If you are getting the error below you either don't have the SSIS+ library installed or the library is not installed properly. I would recommend you uninstall and then reinstall the SSIS+ library. Also check whether the machine you believe you are executing on is the actual machine
Categories: News

Re: SFTP Task Error: File represented by "/somefolder" does not exist

Mon, 05/02/2016 - 22:17
I am receiving the same error. the task is the exact same error. I can reach the files and pull them down using filezilla. however I run any packages (now) and get the same error.
Categories: News

Re: Trying to unzip Zipped file

Fri, 04/29/2016 - 11:03
Hi Ivan, I finally figured out the issue, I have to change two things. It seems like Under CozyRoc Zip task, Dynamic Expressions wont work and lesson learnt here. 1) I have "Delay Validation to True" which concluded me to no issue and after changing to "False", I can see the issue on the "Zip
Categories: News