Viewing 15 posts - 9,856 through 9,870 (of 13,880 total)
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
Maybe try something like
Isnull([Month 01]) && Isnull([Month 02]) etc
May 30, 2013 at 1:09 am
Also, for future info, I've reformatted this (thanks Redgate, but there are free alternatives) and put it in tags. See how much easier it is to read:
select count(tvid)
...
May 29, 2013 at 9:13 am
Viewing 15 posts - 9,856 through 9,870 (of 13,880 total)