Were you able to work around this issue?

I have the same issue. Could you provide the solution?

gilamonster,

it's not your business how people like to answer the questions in the interview. Stop whining ok, you are annoying.

Thank, it helped alot.

Where is the status field? Is it in a SQL Server table?

it's in a table called log where I keep track of the time and downloadStatus

what needs to happen before...

seems like the package hasnt completed. Once completed it turned green.

Can you rollback a transaction on SSIS? Explain step by step how?

Hi Andy,

It's pretty fast. But it only loads 3 records. Wonder how the performance will be for source tables with 500+ million records. Currently I'm designing an incremental load for...

Linux and Oracle doesn't support SSIS transactionOption.

I solved it. Oracle DBA helped me.

It works with table cus. Having the same data type DATE

THANK YOU pduplessis. I REALLY APPRECIATED. I spent the whole day on this package. Thanks again!:w00t::w00t::w00t:

How did you fix it?

Thank Frank.

I got the Expression working. Now I need "select max(LastSuccessfullExtractionDate) from tableLogs" capture this in a variable and use it in my Expression.

My expression looks like:

select * FROM...

Don't use *. Use the column names instead.