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)
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.
is it transformation issue!! please help