This is a newsgroup for discussing COZYROC family of products. Enjoy.
Updated: 1 day 2 min ago
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.
Hi Regor, We plan to release SSIS+ 1.7 officially in December, 2016.
I had the same problem and your solution worked for me. Thanks :) Asif
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.
Jeff, Yes, you can create your own configurations for the REST connection manager. That is one of the major benefits of this technology.
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,
Hi Tracey, I would recommend you check Microsoft's forums how to connect to Office 365 Exchange web services.
Andrew, All component's documentation is posted on COZYROC's website.
Nevermind, I found it. The toolbox items I was looking for only appear under the control flow task, not the data flow task.