Viewing 15 posts - 556 through 570 (of 5,678 total)
Ignore, wrong thread.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 20, 2013 at 3:58 pm
Sorry, took a bit to get back here for me.
Yeah, SSIS is case sensitive. You'll find the same in LOOKUP component too. UPPER() is your friend there.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 20, 2013 at 3:24 pm
Double click on the stream between the excel source and the derived column. First, check the metadata on ColumnX and make sure it's what you expect (in this case,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 5:55 pm
SQLRNNR (12/19/2013)
Where have you been? It seems like forever since I saw the fish in the water cooler icon
Short version: Life.
Self-inflicted financial wounds recovery, a couple of...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 4:57 pm
Wow, that's a heck of a questionairre. #10 is particularly difficult to decide on.
However, good luck on your costume. 😉
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 2:44 pm
It should be similar to this:
(DT_Date)(SUBSTRING("01Feb2012",3,3) + " " + SUBSTRING( "01Feb2012",1,2) + ", " + SUBSTRING( "01Feb2012",6,4))
You may have to tweak it a bit, but it should look like...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 1:41 pm
Shanmuga Raj (12/19/2013)
Sorry for the inconvenience.Since my table did not got pasted properly, i have attached screen shot in below link
please help
I'm afraid I wasn't clear enough and you apparently...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 1:29 pm
Then they're worried about one of two things.
Pre-Compiler/validation times (check into the Execution Results and you'll see them) which you can lookup more information on a number of...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 1:26 pm
He may be part of a group/role that does have access. You have to start with the execution rights on the object and work backwards. Also note that...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 1:12 pm
Help us help you! Remember we're volunteers.
If you're looking for code assistance, we ask you present the data in a way that we can easily turn it into a...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 1:05 pm
IT2012 (12/19/2013)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 1:03 pm
rkaria (12/19/2013)
Hope that makes more sense? Do I still need the database link?THanks
R
Yup, but you're on the wrong forum. Even though you're displaying your output in MS SSRS, the...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 12:18 pm
There's no particular list. It's an open ended question to see how much you know about SSIS package execution and where all the pain points you've experienced are. ...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 12:16 pm
IT2012 (12/19/2013)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 12:08 pm
blasto_max (12/19/2013)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 19, 2013 at 12:02 pm
Viewing 15 posts - 556 through 570 (of 5,678 total)