This is a newsgroup for discussing COZYROC family of products. Enjoy.
Updated: 16 hours 31 min ago
It could be an issue with either firewall.
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
**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:
Contact us to provide what is your licensee identifier . It is hard to tell why the older version works .
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.
Linda, Can you elaborate what do you mean by "package on demand" ?
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.
Hi Sam, I would recommend you review the Microsoft's documentation for the MergeRequest here.
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
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)
Hi, Please post if there is metadata returned for the field and if so what does it show. Thank you!
Mike, You can use this reusable script to check if remote file or folder exists. Use the script with COZYROC Script Task Plus.
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
Hello, We use the regular .NET Regex class for processing the regular expressions. This regular expression looks fine: NM1\*(IL|74)
Hi Leigh Anne, Change the For Each Loop to Foreach from Variable Enumerator and everything will be fine from there.
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
BJ, The parent segment elements should be present in the output setup for the repeating segment "Member Identifier" . Check your columns.
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.
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.
Hi Gediminas, You can specify FLEE expression in the RemoteFilter parameter to select files after certain date/time.