SQLTeam.com | Weblogs | Forums

Delete from ssis is now working

hi all,

I am trying to use SSIS package to update and delete records from flat file to db.

source: Flat file
column: ID (DT_STR) --> changing on the source to (DT_I4)

destination:

DB - table
column : ID (INT)

when i try to connect to traget with oledb command and use command (delete from table where ID(destication) != ID (source)) it deletes all records other then it should be.

Please guide!!!
is it transformation issue!! please help
thanks

Since this processes 1 row at a time, this statement will delete all records except for the 1st ID it finds. Then when it hits the second record it will delete the last record in the table

Delete from table where ID != 1, will delete all records except ID 1. What are you trying to do?