asked on

Split FirstName Middle Initial column using derived column SSIS

I have a column entitled FirstMiddleName that I need to seperate out. I am having trouble with the Derived function for the middle name

Example

John William

It's that simple, space separated. I dont' care much about Names that are supposed to be together (like Mary Ann) I just need them seperated out so I can run a gender match on the name column.

Thanks,

ASKER CERTIFIED SOLUTION

Lee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gwarcher

ASKER

I have a separate table that I run an update with. Do you know how to do it with Derived columns? I'm trying to accomplish this during import.

Lee

Is this a one off import?

Lee

Oh I see, you wanted this in the import ssis package. I just saw the MS SQL Server zone. Sorry I'm not particularly familiar with them. I tend to do a raw import into SQL and then use a stored procedure to process it once inside the DB. Loads easier... assuming you're a confident SQL coder.

gwarcher

ASKER

I'm okay. I have a mass file that I have to update quarterly and the most time efficient way to do it is through SSIS. I think I found something though. Thanks for the help!

gwarcher

ASKER

I fixed it using a sql statement in the SSIS like you said, not going to bother with Derived columsn.

Lee

Glad to have helped. Sometimes it just needs another set of eyes :)