CODEWITHSUNDEEP
mysqlsql-serverssisexecute-sql-taskmysql-odbc-connector
Ali
Ali

Reputation: 99

SSIS Error: Disconnected recordsets are not available from ODBC connections

I have one EXECUTE SQL TASK in SSIS package ,

Task Type: Execute SQL TASK Data Source Type: ODBC for MySql (DSN)

Error :

[Execute SQL Task] Error: Executing the query "select * from nasb_dev.v_borrower_address" failed with the following error: "Disconnected recordsets are not available from ODBC connections.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

it works fine with OLEDB..

any suggestion ?

Upvotes: 1

Views: 1586

Answers (1)

AndreiF
AndreiF

Reputation: 1

You can use an ADO.NET connection with the ODBC Data Provider. This helped me solve the same issue with PostgreSQL.

Upvotes: 0

Related Questions