October 21, 2011 at 8:27 am
hi,
i have few oracle tables.... from there i have to popualte sql
server table based upon last_update_key
the problem is how to pass the "last_update key " that is caliculated
from sqlserver (destination) to oledb sorce query so that the
filtering will happen there at source.
i tried by assignig last_update_date value to variable through
executeSqlTask and
when
i used fallowing query in oledb query
"select * from AP_INVOICES_ALL where LAST_UPDATE_DATE>?"
there is bunch of errors
use of sql command from variable method also throws errors
how to handle the situation
is it possible to filter the data at oledb editor that is connected to oracle based on updated_date_key from sql server or not?
October 21, 2011 at 8:49 am
That syntax looks okay, what were the errors that you were getting?
October 21, 2011 at 10:57 am
when i used to run the package following errors are coming
[OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E10.
and
[SSIS.Pipeline] Error: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009.
more the quer is parsed successfully at oledb source but when i press preview button
it throws errors
'MSDAORA.1' failed with no error message available, result code: DB_E_PARAMNOTOPTIONAL(0x80040E10). (System.Data)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply