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

[Luis_Paez3]

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

[Anonymous]

Thanks.

[SanfordWhiteman]

[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.