12 Replies Latest reply on Aug 25, 2017 12:40 AM by Sanford Whiteman

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



      Please help me how can I extract my marketo leads data into sql server?


      I am trying to extract the Leads data from Marketo using SSIS connector into my MS-SQL Database, We have 1.49 million records in Marketo database after 1.05 Million records the job was cancelling and I am getting  error. so anybody can help me on this why I am unable to get the remaining data, and also let me know is there any restrictions.


      I am getting the below error please take a look into that.


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


      [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on ODBC Source returned error code 0x80004005.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.



      Message was edited by: Prashant Raparla