Good post. Always good to learn something new in the QoD

Point or no point (I selected -1,0,1 which I believe to be the correct answer) at least ensure that the question is legit before posting.

The query goes into the source object. Instead of selecting a table for the source you select SQL Statement and write the select statement you want to use. ...

I have found that the method you are using works if you are not executing the package in the BIDS environment. When I run it like that the CurrentFolder...

I got it right but since when is a Dynamic Management View a table?

Yes that is the question.

Did you try ALTER TABLE [Import].[BOM] WITH CHECK CHECK CONSTRAINT [FK_Base.BOM_LEName]

That will fail also if the data is not correct..... It is checking existing data when you do that....

This is customer data so I can't just delete..... I need to add the WITH NOCHECK for that no futher integrity errors occur while the customer fixes there data...