Thanks for that. How would I create this as a column, rather than it being in a filter? I have a view to which I need to add this to,...

Thank you for this response. It does work, but it's not what I need, because I need to compare with historical data, so I can't use getdata() in this instance....

Hi Zidar,

Here's the create table code and attached is a sample output. Hopefully this helps!

CREATE TABLE [dbo].[FactBP](
[CREATE_DATE] [date] NULL,
[CREATE_TIME] [varchar](8) NULL,
[ADJ_REQ_SHIP] [datetime] NULL,
[RELEASED_DATE] [date] NULL,
[RELEASED_TIME] [varchar](8) NULL,
[ORDER_QTY]...

Thank you so much for your response, I do see the issue here. My problem is that I cannot use getdate, as I am comparing historical data. I'm doing some...

I did do a fresh installation, nothing worked. I created a new project, saved it, tried opening again and the same thing happened.

I clicked on "Delay Validation = true" and that got me through to the data flow task page, but then trying to change the "Validate External Metadata" on the connection...