So, this problem in the data model, that I have described here, is the result of bad design, is what you're saying, right?

Thank you Craig. Have I been assigned to your case? 😎

OK, much thanks.

Jeffrey, thanks.

Do you happen to know if SQL Server 2008 Eval edition is upgradeable to the R2 edition, without uninstall/install?

I have found an iso image of it...but if...

Like this? I get new error.

RESTORE DATABASE IDMine

FROM disk = 'C:\filename.bak'

WITH recovery

,MOVE 'ICE_Sample' to 'C:\ICE_Sample.mdf'

,MOVE 'ICE_Sample_log' to 'C:\ICE_Sample_log.ldf'

Msg 3169, Level 16, State 1, Line 1

The database was backed...

Thanks for replying. No, this didn't work:

RESTORE DATABASE IDMine

FROM disk = 'C:\filename.bak',

WITH recovery,

MOVE 'ICE_Sample' to 'C:ICE_Sample.mdf',

MOVE 'ICE_Sample_log' to 'C:\ICE_Sample_log.ldf'

Msg 156, Level 15, State 1, Line 3

Incorrect syntax near the keyword...

Oh Man, i just had the or operator in wrong place.

so, this worked to handle empty rows from source file:

Condition:

ISNULL([First Name]) == TRUE || [First Name] == "" && ISNULL...

How can i build condition to evaluate an empty string (rather than NULL)?

OK, that helped me fix the syntax, but this did not redirect the 1000+ rows of white spaces I'm trying to redirect:

I set condition to:

ISNULL([First Name])==TRUE && ISNULL([Last Name])==TRUE

Output Name

'Ignored...

Thank you.

What is a good way to handle the situation if the .csv source data filenames have the potential to change? Do I ask that all source files have...

Got it. About the data conversion tool, will try it. Thanks again Koen.

Cool, thank you so much Koen.

Thank you for those answers Phil! (This facet of ETL isn't discussed in SSIS training, beyond configuring the connection manager - simple if everything is on the same...

Thank you for your response. Regarding "I'm not trying to be mean but you might be over your head here if this is business critical". It is business...