Partial load using SQL Select and Where Not Exists
I can't seem to figure out where I am going wrong with regards to writing a partial load statement, using a SQL Select from a SQL Server database, with a Where Not Exists clause. Can anyone provide a good example? Thanks.
Re: Partial load using SQL Select and Where Not Exists
Not sure, but I think there isn't anything what could be compared with exists because it will be only these sql-statement executed. Maybe you could set those load-statement which created the exists-matchingfield in the partial load, too.