SQLTeam.com | Weblogs | Forums

SSIS - lookup transformation


I have a package which exports an excel data feed. I need to send amendments to the data each day, so I set up two tables for 'new' and 'old', The package and lookup runs perfectly picking up the rows with amendments and populating my excel feed, however it populates all fields per row. I need to only populate the field(s) that have changed i.e. return NULL where there is no change. Is there an easy way to do this within mapping or the lookup transformation?


You could use a Derived Column transformation for that. Assuming old and new values are in the same datastream:

Old == New ? NULL(DT_whatever) : New


Of course... why didn't I think of that!? I've done it. It works. I'm happy.

Thank you very much! :smile: