Stack Overflow
Stack Overflow

Questions tagged [cozyroc]

12 questions
2
votes
0 answers

SSIS File System Task Doesn't Work but Reports Success

I created an SSIS package that extracts two files from a .zip file, imports data from them and then attempts to delete the files that were extracted. The package works, data is imported and all tasks report success. However the File System Tasks…
Robbie
  • 71
  • 4
2
votes
0 answers

Non-consistent SSIS error 'Opening a rowset for "%1" failed.' when using COZYROC dataflowtask+

In a daily process only sometimes (so far 2 times, more than 15 days apart) it fails with a message "Opening a rowset for "%1" failed." This error happens in a DataFlowTask+ which reads a view and materializes it in a table. The error usually…
Bernat Agulló
  • 43
  • 7
1
vote
1 answer

Need code to generate and SSIS Package with BIML containing a COZYROC Table Difference component

Can anyone please help with a code sample showing how to generate an SSIS package using BIML that contains a COZYROC Table Difference Component? I found a piece of sample code on BimlScript.com that looks like the code you would expect to see up to…
DrLechter
  • 135
  • 5
1
vote
0 answers

I am not able to see Data Flow Task Plus ext [ Cozyroc SSIS + ( 2.0 Licensed=Trial)] in SSIS Toolbox

The applications I am using on my machine : Visual Studio 2019 SQL Server 2016 SQL Server Management Studio (SSMS) 19 Cozyroc SSIS+ 2.0 ( Licensed : Trial ) After installing the cozyroc SSIS+ ( Roaming Mode ) , I am not able to see it in SSIS…
Tanmay Salunke
  • 11
  • 1
1
vote
2 answers

How to build SSIS package to UPSERT/DELETE data from Salesforce to SQL Server database?

I need to pull data from Salesforce to a SQL Server 2017 instance (one way) using SSIS+ (third party - CozyRock). Now the issue is to retrieve the data and not duplicate it in the SQL Server database? I was wondering also if I can build a button on…
AjFmO
  • 395
  • 2
  • 4
  • 18
0
votes
0 answers

How to configure a rest api parameter that accepts list of string usernames into cozyroc

Im trying to configure cozyroc to call rest api in a SSIS project. The api that i intend to call has a request param to accept list of usernames. The username data type is string. I unable to configure the list data type in cozyroc A proper guidance…
harvinderan chandran
  • 1
0
votes
0 answers

Web Rest API and SSIS - where to start

We are creating a series of SSIS packages to interact with the Walmart Marketplace APIs and trying to use CozyRoc rest components. They do not have all of the APIs stubbed out and our team has little knowledge around OpenAPI or how to configure…
MadRaven
  • 16
  • 2
0
votes
0 answers

Exception handling in SSIS Task for Hive Commands to run on Linux server from SSIS Package

I'm executing SSIS Task, Task is about running the file(which contains hive commands) on a Linux server from the SSIS package using SSH Connection manager by copying files to Linux server and passing a command from SSIS Task to execute the…
VamsiKumar_gudala
  • 41
  • 5
0
votes
0 answers

SSIS - COZYROCK Zip Task Editor differente files

I need some help. I'm trying to zip 3 files, as I you can see in the image But i only want to zip the two .pdf files (the name is dynamic) and the xml file. I want to ignore the others .zip files that exist in that folder. Anyone knows? Thanks in…
AlexandreG
  • 13
  • 4
0
votes
0 answers

SSIS File Transfer task use a wrong cipher

I'm using CozyRoc 1.6 and I am trying to connect to an FTPS (TLS1.2) using the connection…
falopafalopa falopa
  • 1
0
votes
1 answer

Hardcoded Mapping to the Destination

I am trying to create a SSIS package for the interface between SQL Server and the Salesforce. I have created the connection between the systems and using a third party COZYROC Connector for SF connection and the data flow looks like below I am not…
trx
  • 2,077
  • 9
  • 48
  • 97
-1
votes
2 answers

Google Analytics API for dateRange of previous month

We are reading the Google Analytics data using Cozyroc REST Source component in SSIS package. While reading the data, I can add the dateRange startDate and endDate in 'YYYY-MM-DD' format. Instead of adding static values, I wanted to read the data…
Ajit Medhekar
  • 1,018
  • 1
  • 10
  • 39