SSIS Devart Marketing Cloud Source Component

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
Asmitty1182
Posts: 1
Joined: Mon 18 Mar 2019 20:01

SSIS Devart Marketing Cloud Source Component

Post by Asmitty1182 » Mon 18 Mar 2019 20:05

Hello,

I wanted to trial your Exact Target SSIS Components before purchasing them. I’m having issues with Exact Target Source Component. I was able to login to SalesForce Marketing Cloud but cannot access any of Tables I see listed inside of SSIS. I can’t see Field Names for any of tables. Do you know what is causing this issue. Let me know my company will purchase these components if we can extract data from them."Invalid Response from Service" is the error message I am dealing with when trying to drill down on a table in the Marketing Cloud Source Component

Shalex
Site Admin
Posts: 8597
Joined: Thu 14 Aug 2008 12:44

Re: SSIS Devart Marketing Cloud Source Component

Post by Shalex » Wed 20 Mar 2019 10:44

Our component expects XML data from the service, the "Invalid Response from Service" error means that the received data could not be parsed by the XML parser.

1. With Authentication Type=UserNamePassword, have you initialized the Host connection string parameter with the value that corresponds to your instance?

JIC: https://www.devart.com/dotconnect/exact ... cting.html
Host -> URL of an ExactTarget instance for API UserNamePassword authentication. By default the S1 Instance address is used: https://webservice.exacttarget.com/Serv ... -links.htm.

2. Could you please register at https://skyvia.com/, create the Salesforce Marketing Cloud connection, use this connection in some simple package (e.g.: export package) to reproduce the error? Then, specify via contact form your account name and package ID so that we can investigate logs for getting detailed information about the issue.

Post Reply