Viewing 15 posts - 541 through 555 (of 5,678 total)
Kannan Vignesh (1/3/2014)
i am Kannan.
Hello, welcome to SSC.
i need tmplate for loading flat files into staging as well as historical simultaneously.
You've combined three things here at once.
First, 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
January 3, 2014 at 4:47 pm
No. Passing in and out of the variables set in SSIS is byVal only. You need to use the long name. If you're going to manipulate it...
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 1, 2014 at 12:06 pm
I'd like to add a special case to the general philosophy here. I worked on a BLOB system that was the majority of storage in the DB, and we...
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 31, 2013 at 11:03 am
LinksUp (12/30/2013)
Having...
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 30, 2013 at 6:54 pm
You'll have to go to dynamic SQL to pull this off.
This article will point you at the generic idea:
https://www.simple-talk.com/blogs/2007/09/14/pivots-with-dynamic-columns-in-sql-server-2005/
Also, you'll need to name your columns something like Apr13 and Apr12...
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 30, 2013 at 4:05 pm
petr.caslavka (12/30/2013)
Evil Craig,absolutely love your sense of humor and your comments.
Well, thank you. 🙂
On the first issue: 1. There is a very distinct reason for this piece of code and...
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 30, 2013 at 4:02 pm
blasto_max (12/30/2013)
open the script in the designer by clicking Edit Script button and
make sure it...
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 30, 2013 at 2:56 pm
In pieces:
--If Time Clock Details Table doesn't have the number of columns we're expecting, then abort
DECLARE @ColumnCount INT
SET @ColumnCount = (SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name = 'ps_micros_e7_time_clock_details' AND column_name...
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 30, 2013 at 2:50 pm
SSIS doesn't like dynamic metadata, so you can't really use the basic tools in SSIS for something like that, you'd have to create source/targets for each table.
There are some third...
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 30, 2013 at 2:33 pm
I highly recommend putting the DB into single user mode, to avoid possible usage overlaps and concerns. You'll want to take the DB basically offline while you do 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
December 30, 2013 at 1:43 pm
Karthiart,
If you only have two files like this, I would recommend the above, as it's simpler.
However, if you have multiple XML files missing attribute tags depending on the source, but...
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 30, 2013 at 1:38 pm
ScottPletcher (12/20/2013)
The smarmy condescension really isn't justified,
Wasn't justified either way. My apologies, that was undeserved. It didn't read that way to me when I first wrote it.
given...
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 5:35 pm
Apologies, I missed your split response on this earlier. I scrolled too quickly.
I wasn't ignoring anything. Me real point was that indexes could be modified in the future in...
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 5:26 pm
ScottPletcher (12/20/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 20, 2013 at 5:02 pm
Jeff, neat trick with the a.Field > ''. Was unaware of that.
ScottPletcher (12/20/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 20, 2013 at 4:02 pm
Viewing 15 posts - 541 through 555 (of 5,678 total)