Sql Update Datetimeoffset

• Update Datetimeoffset Sql

Update Datetimeoffset Sql

I'm designing a SSIS package that pushes delta records from one SQL DB to another using Script Task. I've a control flow with Execute SQL task and Script task. Execute SQL Task reads data from source database which is inserted/updated after last successfulrun date. I'm storing last successful run date in a XML file on file server. After reading data from source DB it uses Script Task to push data through another application database using web services. After successful run, I update the Last Successful Rundate in XML file which will be read when the SSIS package runs next time using SQL Agent Job. Last Successful Run Date is being updated in XML in 'dd/MM/yyyy hh:mm:ss tt' ( 10:10:15 AM) format.

My SQL Task has query like.SELECT col1, col2 FROM Table1 WHERE InsertDate @LastSuccessfulRunDate OR UpdateDate @LastSuccessfulRunDate.InsertDate and Update columns are of type DateTimeOffset(7). When I run this query I'm not getting any records even if the records are inserted/updated after given time.Anyhelp would be appreciated.Thanks.