Error: SQLSTATE: HY010, Message: [Microsoft][ODBC Driver Manager] Function sequence error in SSIS

[ThiagoGeneroso]

Hi guys!

I created a process in SSIS 2019 that uses a source ODBC with connection to Sybase IQ, I am using a ForEach Loop to loop by date passing as a parameter and loading the data into SQL Server through Target OLE DB.

I'm getting the error: "SQLSTATE: HY010, message: [Microsoft] [ODBC Driver Manager] Function sequence error"

Has anyone received this error ??

can you help me?

[#2]

@ThiagoGeneroso This is known issue until CU6. Fix is there in CU7 but CU7 have some other snapshot related issues. You can install SQL 2019 CU8 to fix this.