Forum

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

Re: SFTP: No connection could be made because the target machine actively refused it. (INTERMITTENT)

Thu, 03/16/2017 - 09:55
It could be an issue with either firewall.
Categories: News

Dynamics GP ObjectCriteriaXML Examples

Tue, 02/28/2017 - 11:25
Hi I am in the middle of evaluating the Cozyroc Dynamics GP tools. I'm very comfortable using SSIS and have used Scribe in the past to integrate to Dynamics but I'd prefer to use SSIS on this project. I have managed to get simple queries to work without a problem but I'm having problems when I
Categories: News

**we provide GC and USC only**

Tue, 02/21/2017 - 19:08
**we provide GC and USC only** we provide Genuine candidates for all technologies Please forward your requirements to my mail Id:da...@golokglobal.com Desk No:
Categories: News

Re: Rebex.Net.SshException: Key exchange failed.

Thu, 01/26/2017 - 18:04
Contact us to provide what is your licensee identifier . It is hard to tell why the older version works .
Categories: News

Zendesk API support

Wed, 01/25/2017 - 12:28
Are there any plans to implement Zendesk as a configuration for the REST object? My company is looking for the ability to create tickets using an automated tool and there are options available but I don't want to switch from Cozyroc just for that.
Categories: News

Re: Migrating to new versions and servers and getting license not found error

Sat, 01/21/2017 - 19:51
Linda, Can you elaborate what do you mean by "package on demand" ?
Categories: News

Re: Retries in SFTP

Tue, 01/17/2017 - 11:01
Hi, There is no Retry implemented in the SFTP Task. You can implement a retry using the standard SSIS For Each Loop container by having the SFTP Task that you expect to fail setup in it.
Categories: News

Re: Questions about the DynamicsCrmMergeDestination Script Component

Mon, 01/16/2017 - 23:14
Hi Sam, I would recommend you review the Microsoft's documentation for the MergeRequest here.
Categories: News

Re: cozy roc remote file list help

Wed, 01/11/2017 - 12:01
Hi Ivan, We found out what the issue is. We changed the code to a list. Here is the code. I wanted to put this out there in case someone else in the future runs into this issue. Public Sub Main() Dim list() As Object = Dts.Variables("User::RemoteFileList").Value If
Categories: News

Re: Column missing in Salesforce Source Connector

Tue, 01/10/2017 - 20:53
We got it resolved. We were calling the wrong API to Sales Force. Once we fixed that the problem is resolved. Thanks. Razzakul Chowdhury (Raz)
Categories: News

Re: REST Source - ServiceNow

Mon, 01/09/2017 - 08:53
Hi, Please post if there is metadata returned for the field and if so what does it show. Thank you!
Categories: News

Re: Using IsDirectory in remote filter

Wed, 01/04/2017 - 20:24
Mike, You can use this reusable script to check if remote file or folder exists. Use the script with COZYROC Script Task Plus.
Categories: News

Re: FEL combining Excel Task Plus and Excel Source Plus

Wed, 01/04/2017 - 15:38
I finally got it to work, but I'm honestly not sure how. Right now, I have that Excel Connection manager set up with 2 expressions. One is for the connection string and one is for the Excel File Path. I have them both set to use the results of that first FEL workbook loop. It's working so I'm
Categories: News

Re: EDI Source Regular Expression Syntax

Tue, 01/03/2017 - 11:14
Hello, We use the regular .NET Regex class for processing the regular expressions. This regular expression looks fine: NM1\*(IL|74)
Categories: News

Re: Excel Task -- Results Variable data type

Wed, 12/28/2016 - 18:44
Hi Leigh Anne, Change the For Each Loop to Foreach from Variable Enumerator and everything will be fine from there.
Categories: News

Re: Data Flow Task Plus - Multiple SQL views to multiple flat_files

Tue, 12/20/2016 - 11:03
Leigh Anne, Congratz! ;) Without knowing what you did have setup in the previous packages, it is hard to tell what is wrong. The Mapping parameter has to be setup only if the destination columns differ from the source columns. The ColumnDelimiter parameter has to be setup, but if you are setting
Categories: News

Re: Install problems

Thu, 12/15/2016 - 17:23
BJ, The parent segment elements should be present in the output setup for the repeating segment "Member Identifier" . Check your columns.
Categories: News

Re: Salesforce SSIS connector & DT_DBTIMESTAMPOFFSET

Wed, 12/14/2016 - 13:40
Hi Tad, By default the date/time columns extracted from Salesforce are converted to the server's local time. You can use Time Zone Transformation reusable script here to convert the date/time columns to the timezone you prefer.
Categories: News

Re: EDI Source - XML Mapping

Wed, 12/14/2016 - 12:01
Jeffry, Change only the output column metadata. Do not modify the external column metadata. In this way the smart refresh will not change your output column setup.
Categories: News

Re: How to use SSH Execute task

Fri, 12/02/2016 - 09:36
Hi Gediminas, You can specify FLEE expression in the RemoteFilter parameter to select files after certain date/time.
Categories: News