the oledb source is not accepting parameters for sql commands with sub queries....... so i need the joins instead of subqueries..!

"SELECT * FROM table WHERE LAST_UPDATE_DATE =>" TO_DATE(+@UdateKey,''YYYY-MM-DD HH24:MI:SS')

the expression is going to work

can you give me correct way? , it helps me a lot

i ahve to stright copy the data for sigle time.

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

hi i am new to ssis

can you eloborate it..

oracle source(oledbSource)----oledb destination(sqlserver)

i will collect it from sql server table (destination).......some max(updatedate) ...

but "how to pass it...