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

%3CLINGO-SUB%20id%3D%22lingo-sub-1314255%22%20slang%3D%22en-US%22%3EError%3A%20SQLSTATE%3A%20HY010%2C%20Message%3A%20%5BMicrosoft%5D%5BODBC%20Driver%20Manager%5D%20Function%20sequence%20error%20in%20SSIS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1314255%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20process%20in%20SSIS%202019%20that%20uses%20a%20source%20ODBC%20with%20connection%20to%20Sybase%20IQ%2C%20I%20am%20using%20a%20ForEach%20Loop%20to%20loop%20by%20date%20passing%20as%20a%20parameter%20and%20loading%20the%20data%20into%20SQL%20Server%20through%20Target%20OLE%20DB.%3C%2FP%3E%3CP%3EI'm%20getting%20the%20error%3A%20%22SQLSTATE%3A%20HY010%2C%20message%3A%20%5BMicrosoft%5D%20%5BODBC%20Driver%20Manager%5D%20Function%20sequence%20error%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20received%20this%20error%20%3F%3F%3C%2FP%3E%3CP%3Ecan%20you%20help%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1796164%22%20slang%3D%22en-US%22%3ERe%3A%20Error%3A%20SQLSTATE%3A%20HY010%2C%20Message%3A%20%5BMicrosoft%5D%5BODBC%20Driver%20Manager%5D%20Function%20sequence%20error%20in%20SSI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796164%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F625336%22%20target%3D%22_blank%22%3E%40ThiagoGeneroso%3C%2FA%3E%26nbsp%3BThis%20is%20known%20issue%20until%20CU6.%20Fix%20is%20there%20in%20CU7%20but%20CU7%20have%20some%20other%20snapshot%20related%20issues.%20You%20can%20install%20SQL%202019%20CU8%20to%20fix%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

1 Reply

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