Attempting to import data from sybase to SQL Server. I Created a SSIS Pacakge with a ADO Net Source with Datasource connection like so
and I get a test that is successful like so
however when i try to run the package i get this error
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "ADO NET Source" (1243) failed validation and returned error code 0x80131937.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
Any help of how to get rid of this error.