Viewing 15 posts - 9,091 through 9,105 (of 13,876 total)
ronan.healy (9/9/2014)
ill probably have to use an sql script to update the columns as that doesn't get all 3 in for me
Please explain why not.
I thought you wanted Comp A,...
September 9, 2014 at 3:35 am
Perhaps something like this?
BASIS_IND == "A" ||BASIS_IND == "T" ?: "Comp " + BASIS_IND : "Comp"
You might need to use & instead of + to concatenate the text - can't...
September 8, 2014 at 8:37 am
ronan.healy (9/8/2014)
ok is there anyway I cant put the 3 rd expression in as anything that's not a or t I just want as comp
There is no need for a...
September 8, 2014 at 8:33 am
The basic syntax is as follows:
boolean_expression?expression1:expression2
Your expression
BASIS_IND == "A" ||BASIS_IND == "T" ?: "Comp A": "Comp T" : "Comp"
has an 'expression3' - which I imagine is causing the error. (In...
September 8, 2014 at 7:51 am
vijayalakshmii.venkatesh (9/5/2014)
Can I achieve this through Excecute process Task...
September 5, 2014 at 2:58 am
If you remove the AND clause completely, are the required rows displayed?
Please do a SELECT from dbo.cdbAttribInst showing the value of ainAttribID for the rows you want to appear and...
September 5, 2014 at 1:31 am
There is an SSIS System Variable called 'StartTime'.
You may be able to create an Expression which uses this, thus avoiding the need for a Script Task.
September 5, 2014 at 1:13 am
cstrati (9/5/2014)
Thanks for your reply.
Unfortunately I've ran your script and I'm getting the same 4 results.
It doesn't appear that the columns that are emtpy display when adding 'Null'...
September 5, 2014 at 1:01 am
Also, if lots of data is involved, that WHERE clause is going to tax the database engine because of all those function calls. We may be able to help optimise...
September 5, 2014 at 12:46 am
cstrati (9/5/2014)
When I add another table to this view to display the Industry...
September 5, 2014 at 12:44 am
mark 66658 (9/3/2014)
September 4, 2014 at 12:27 am
I also like the derived column idea.
Replace ')' with '' (empty string).
Replace '(' with '-' (minus)
August 28, 2014 at 1:51 am
Koen Verbeeck (8/28/2014)
Open one solution. Right-click on SSIS Packages and select "Add existing package". Browse to another solution and add the package from there.
+1
August 28, 2014 at 1:48 am
ronan.healy (8/27/2014)
so all the columns will always have that date format and I want to text the text after the...
August 27, 2014 at 3:56 am
Viewing 15 posts - 9,091 through 9,105 (of 13,876 total)