Thanks guys, that works a treat. 🙂

I'm guessing you can't replace the same column twice and so have to use 2 derived columns.

Also trying to convert Y to 1 and...

I suppose the biggest question is... does that use REPLACE from the SQL Server or as part of the .net

The server collation being case insensitive and this particular search/replace I...

Thanks for all the help so far.

Conditional Splits... You'd recommend Source -> Lookup -> Conditional => Outputs ? With the error outputting of the lookup set to ignore errors?

Edit: Nevermind,...

I've just seen that in the Ole Db Command component, very nice. It's a shame it's not easy to identify which param_0 is when mapping them etc. Gotta remember the...

Okay thanks, will try the conditional split. I'll switch them from fail/pass lookup to conditional switch.

But I still don't know how to update a record though. I can't see a...

I have managed to get it to insert new records that don't already exist now. Using

Data Flow with Flat File Source -> Lookup that checks record exists and on failure...