Viewing 15 posts - 1,891 through 1,905 (of 5,678 total)
barry.pettis (1/24/2012)
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
January 24, 2012 at 2:50 pm
A couple of things to check. First, find out if your testuser is associated to any other roles. Then, double check there isn't an explicit deny on this...
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
January 24, 2012 at 2:43 pm
sqlsponge2 (1/24/2012)
It appears to be coming in through the OLE DB source as (string [DT_STR]) and comparing in the Lookup to (string [DT_STR]).
Hm. 11 records that won't associate, they're...
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
January 24, 2012 at 12:45 pm
Laura_SqlNovice (1/24/2012)
Comments I added for the forum...
Then we haven't seen the original, which makes troubleshooting things like this tougher.
This is the test server where we got the issue...
Microsoft SQL...
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
January 24, 2012 at 11:49 am
+1 for OLEDB on both sides for SQL to SQL transfers. It's simple to setup, easy to use, little difficulty in transferring it to others, and uses the native...
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
January 24, 2012 at 11:45 am
Ran into this myself. There's no way to prioritize multiple streams in the same data flow.
However, create two separate dataflows in the same controlflow. Use a script component...
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
January 24, 2012 at 11:43 am
What is the metadata type of the column with the GUID as it enters the lookup component? I've seen that end up funky before, and then it tries to...
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
January 24, 2012 at 11:40 am
Charmer (1/24/2012)
Hi friend,my source is oledb only...
Than FOR XML is probably best. Why avoid the easy method?
Could you gimme some samples to do this in script component..?
i am not...
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
January 24, 2012 at 11:35 am
For raw data copying I'd go with replication. For immediate data transfers with asynchronous transactions (ie: sending to an audit table on every update via trigger), or manipulated data,...
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
January 24, 2012 at 11:22 am
Laura_SqlNovice (1/24/2012)
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
January 24, 2012 at 11:18 am
Sounds a lot like the information description storage for something like CNet, or any other massive product review database. There's some free to try ones out there that you...
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
January 23, 2012 at 9:39 pm
Jeff Moden (1/23/2012)
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
January 23, 2012 at 7:31 pm
Charmer (1/23/2012)
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
January 23, 2012 at 6:41 pm
*blink*
9/11 boat lift. Apparently it took forever for someone to document this. Half a million people in 9 hours.
http://forum.woodenboat.com/showthread.php?136581-BoatLift-An-Untold-tale-of-September-11-Resilience
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
January 23, 2012 at 3:25 pm
You'll want to use the FOR XML trick.
This article will walk you through it:
http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/
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
January 23, 2012 at 2:18 pm
Viewing 15 posts - 1,891 through 1,905 (of 5,678 total)