Hi All,
I have an SSIS package developed in VS 2019. It has an ODBC Oracle source with millions of records in a table. It transfers data to a SQL Destination. I'm trying to transfer 1 million record at a time by dynamically generating the SQL to use ROWNUM feature. My Source query looks something like this,
"SELECT * FROM (SELECT a.id, a. a.fld , a.mod_user_id, a.fld_vl_ext, ROWNUM r FROM adm.tusrvl a) WHERE r >" + @[User::intRCountStart] + " and r < " + @[User::intRCountEnd]
When I hit the preview button, I get the following error,
SQLSTATE: HY000, Message: [Microsoft][ODBC Oracle Wire Protocol driver]General error. setStmtType failed;
It this the right way of passing variables to Source query? Has anyone tried this and seen this error?
Environment:
Windows 10, Visual Studio 2019
Kind Regards,
Deepak