How to extract Marketo Leads into my SQL Server using SSIS?

Highlighted
Level 2

Re: How to extract Marketo Leads into my SQL Server using SSIS?

Sorry I've never dealt with SSIS & Marketo specifically but its worth a search on the web.

Highlighted
Anonymous
Not applicable

Re: How to extract Marketo Leads into my SQL Server using SSIS?

Thanks.

Level 10 - Community Moderator

Re: How to extract Marketo Leads into my SQL Server using SSIS?

[ODBC Source [2]] Error: Open Database Connectivity (ODBC) error occurred. state: 'HY000'. Native Error Code: -1. Marketo Request Failed - 601: Access token invalid

This error partway through a job means the access token (which has a 1 hour TTL) expired. My experience w/CData products is that they have a token retry/renew process, at least for their OData Server.. You should open a support case with them to find out why that isn't working here.