I want to use Microsoft SSIS 2015 to extract Marketo lead data and put it into a SQL database. Has anyone successfully done this? There is a post on this Discussion forum from August 2017 but it doesn't seem like it was successful. There is a Web Service task in SSIS that looked promising, I am not sure on what URL to put in the Server URL field for the HTTP Connection Manager Editor setting.
I want to automate the SSIS package to run overnight, so not interested in the Marketo Bulk Export option.
Has anyone been able to do this data extract via SSIS?