I have a tricky question. I have two sources. They will contain more or less the same information. E.g. TABLE A and TABLE B What are the records different from table a to table b ? So I would like to output what are the the record among them different. (a sort of opposite of join). Any Ideas? Thanks in advance

So basically you need to use two joins: one LEFT OUTER JOIN to get the NULLs returned from tableA, then RIGHT one to get the records from table B You can use two Merge Join Transformations; that should be similar to what has been described in this blog post: http://beyondrelational.com/modules/2/blogs/101/posts/13416/ssis-97-when-merge-join-is-your-friend.aspx Arthur My Blog

Thanks for your great help... Silly question how to get the null value? On a sql query it's very easy to find an isnull function but in the integration service is there something as a filter ? Conditional split ?

It is a legit question. You need then to split the output using ISNULL SSIS Expression in the Split Transformation. I was able to Bing you even a better article that offers two approaches -http://www.sqlis.com/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspx You must be all set after you skim through it.Arthur My Blog