Lowell, I have a select query that I use as the 'architectural plan' for my SSIS package. From this experience I have noticed that because the source of my...

TRIM did the trick.

thank you very much!!!!!

Hi Lowell, you posted while I was replying to Dave23. Thanks.

Well,

1. I've got a conditional split diverting only those rows where the destination column is missing a value

2. Following...

Hi Dave 23, thanks for replying.

When I run it I just get the whole [Business Unit] string value.

I have also tried:

SUBSTRING([Business Unit],4,LEN([Business Unit]) - 3)

and that returns the whole [Business...

Vikash, Phil, somebody?

[Business Unit] is MFMGOOGLE and I want just the 'GOOGLE' part.

This parses in the Derived Column transformation but isn't working as intended:

SUBSTRING([Business Unit],4,LEN([Business Unit]) - 3)

How to fix...

Phil, I modified my post while you were answering. I'm not placing the burden of this question on you, but I decided to push it a little further (if you...

That worked. Thanks Phil. I was trying to accomplish before unpivot.

In my dataset I sometimes have rows, where all 12 of the 12 rows that I am unpivoting (using...

Phil, turns out that Derived Column is not for such kind of work because I am needing to filter rows and not handle them ie. concatenate, rename, test a condition,...

I found the source of the problem.

When the UNPIVOT transform runs into a row, where every column which is being unpivoted contains a null value, rather than ignore...

good idea.

so far I had only made a subset of the source data (10 rows) and replicated the rowcount problem (20 output with unpivot transform and something like 17...

Phil, you've always been spot on for me in the past, so I was :w00t: and :ermm: and :crazy:. and a little bit wondering if it had more to do...

Sought advice from colleague.

This worked (double quotes encasing a space)

[Copy of Obj Acct] == " " ? [Copy of Sub] : ([Copy of Sub] == " " ?...

Phil, I don't get what you're saying. How would a Lookup table help me in a situation where I need to derive new values in the source table based on...

in case it helps someone else, the video that helped me get Lookups straight was the one posted earlier plus this one

http://www.youtube.com/watch?v=PQ1eM0TUdl0

Vikash,

I would like the expression to evaluate without quotes around zero:

[Obj Acct] == 0? Sub : (Sub == 0? [Obj Acct] : [Obj Acct] + "." + Sub)[/

so that...