Viewing 15 posts - 9,856 through 9,870 (of 13,879 total)
If field2 is a datetime, trying to return 'nothing' if it is null will be giving the database engine a headache in terms of mismatching data types.
Instead, maybe try returning...
June 4, 2013 at 1:47 am
KoldCoffee (6/3/2013)
it does not parse.:-P
I just created a text file to check this. It parses for me.
--Edit: added screen shot
June 4, 2013 at 1:22 am
bobd125 (6/3/2013)
June 4, 2013 at 1:04 am
homebrew01 (6/3/2013)
June 3, 2013 at 10:53 am
What do you mean by 'wrong'? Looks OK to me. Does it not parse?
June 3, 2013 at 10:40 am
You can right-click on a task and select 'Execute Task' - is that what you're after?
June 3, 2013 at 10:38 am
Well, I counted only one colon (:) even though you have two conditions. Everything needs to balance.
No nesting:
expression1?true1:false1
Insert one level of nesting:
expression1?(expression2?true2:false2):false1
June 3, 2013 at 9:14 am
KoldCoffee (6/2/2013)
To be sure, you could try something like:
SUBSTRING(TRIM([Business Unit]), 1, 3) == "MFM" ? SUBSTRING(TRIM([Business Unit]), 4, 50): [Business Unit]
--snip
I've tried this but it doesn't...
June 3, 2013 at 6:38 am
Nimesh_Parikh (5/31/2013)
I know I am asking very silly question, But We have put all our efforts to develop SSIS 2012 solution and now customer requirement changes and they wants to...
May 31, 2013 at 9:17 am
.. use indent, otherwise code looks like noodles.
:hehe:
May 31, 2013 at 12:56 am
Conditional Split is the task you need. Add it after the derived column from the previous post. Send all NULLs to one output and everything else to the other. Then...
May 30, 2013 at 6:17 am
Great, thanks for posting back.
May 30, 2013 at 2:06 am
Nomvula (5/30/2013)
i have excel souce with data that i need to import into oledb destination, here's an example of my the import
INVOICE DESCRIPTIONPOSTING DATE
Posted ...
May 30, 2013 at 1:42 am
Viewing 15 posts - 9,856 through 9,870 (of 13,879 total)