AnsweredAssumed Answered

Connecting to FileMaker using SSIS

Question asked by FedericoGauss on May 23, 2016

I work at a printing company as a FileMaker developer. I rarely use the ODBC connectivity features, but my co-worker ran into the following problem, and I would appreciate any help in finding a solution:


"In Visual Studio 2010, I can preview the data using an ODBC connection to FileMaker, but when I try to debug the task  I get the error below:


[SSIS.Pipeline] Error: "ODBC Source" failed validation and returned validation status "VS_ISBROKEN".


If I turn the ValidateExternalMetadata off, I get this error:


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


Thanks so much,


Gauss Rescigno