Syndicate content
This is a newsgroup for discussing COZYROC family of products. Enjoy.
Updated: 1 day 2 min ago

Re: cozy roc remote file list help

Wed, 01/11/2017 - 11: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 - 19: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 - 07: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 - 19: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 - 14: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 - 10: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 - 17: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 - 10: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 - 16: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 - 12: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 - 11: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 - 08:36
Hi Gediminas, You can specify FLEE expression in the RemoteFilter parameter to select files after certain date/time.
Categories: News

Re: Projected Production Release of COZYROC 1.7

Wed, 11/30/2016 - 12:11
Hi Regor, We plan to release SSIS+ 1.7 officially in December, 2016.
Categories: News

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

Tue, 11/29/2016 - 08:37
I had the same problem and your solution worked for me. Thanks :) Asif
Categories: News

Re: Version 1.6 won't uninstall

Fri, 11/18/2016 - 07:25
In case anyone else has a similar problem I finally managed to get Version 1.6 uninstalled by using IObit Uninstaller, having had no success with the Microsoft uninstaller tool nor a couple of others.
Categories: News

Re: Custom Configurations for REST Connection

Thu, 11/17/2016 - 16:32
Jeff, Yes, you can create your own configurations for the REST connection manager. That is one of the major benefits of this technology.
Categories: News

SSIS+ - Deploy 1.7 Zip Task SQL Server 2016 Testing - Backward Comparability

Thu, 11/17/2016 - 16:00
I built an SSIS package using v 1.7 of the CozyRoc Zip Task, and deployed to a 2016 SQL Server, using Visual Studio 2015 with the SSIS Project Deployment Target set toSQL Server 2016. Everything worked fine. If I change the Deployment Target Parameter to SQL Server 2014 in the SSIS Project,
Categories: News

Re: Exchange connection manager and Office365

Wed, 11/16/2016 - 17:30
Hi Tracey, I would recommend you check Microsoft's forums how to connect to Office 365 Exchange web services.
Categories: News

Re: SSIS+ Excel Macro

Wed, 11/09/2016 - 17:55
Andrew, All component's documentation is posted on COZYROC's website.
Categories: News

Re: Cannot add SSIS Control Flow Toolbox Items tab under Choose Toolbox Items

Wed, 11/09/2016 - 15:32
Nevermind, I found it. The toolbox items I was looking for only appear under the control flow task, not the data flow task.
Categories: News