TechQA.

SSIS Error: Disconnected recordsets are not available from ODBC connections

1.2k views Asked by At

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 ?

mysql sql-server ssis execute-sql-task mysql-odbc-connector
Original Q&A
0

There are 0 answers

Related Questions in MYSQL

Related Questions in SQL-SERVER

Related Questions in SSIS

Related Questions in EXECUTE-SQL-TASK

Related Questions in MYSQL-ODBC-CONNECTOR

Popular Questions

Popular Tags

javascript python java c# php android html jquery c++ css ios sql mysql r reactjs node.js arrays c asp.net json python-3.x ruby-on-rails .net sql-server swift django angular objective-c pandas excel

Trending Questions