Viewing 15 posts - 916 through 930 (of 5,678 total)
Grass (12/18/2012)
I want to know from T-SQL(store proc) in a staging table and also SSIS.
In T-SQL you'd simply use a CASE satement in your INSERT/Update statements, something like
CASE WHEN LEFT(...
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 18, 2012 at 4:18 pm
support 86837 (12/18/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
December 18, 2012 at 4:15 pm
sql1411 (12/18/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
December 18, 2012 at 4:13 pm
What are you using for the data load? Bulk Import? SSIS? SCD T-SQL script off a staging table?
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 18, 2012 at 3:24 pm
Just a few clarifications, if I understand this right.
In the pts columns, for the final item, shouldn't pts1 be 0 and Pts2 be -1100 to zero the account off?
Can 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 18, 2012 at 3:22 pm
Oh, such fun, lot rezonings. Used to work in land appraising. Brings back memories. ... errr... I'm digressing.
My apologies for the initial confusion. I thought 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
December 18, 2012 at 3:14 pm
GYEAH... nHibernate.
Can you get a hand on your coders to explore the underlying foundation calls? If you can, they can probably get you a better idea of what 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 18, 2012 at 3:04 pm
Export the package to a dtsx file and get it into BIDS/VisStudio. You need to see what the problem is. Usually it's a schema modification screwing up metadata...
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 18, 2012 at 2:58 pm
Does it have a rss stream or are you scraping the data off the page? What format are you getting it in?
Usually sites like that have the ability 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
December 18, 2012 at 2:51 pm
What are you intending to do with the resultant #temptable? The syntax issue you're running into is:
SELECT whatever INTO #table FROM tablexyz.
Alternatively CREATE TABLE #table INSERT INTO...
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 18, 2012 at 2:50 pm
GSquared (12/18/2012)
A good book runs about $8 on average these days, and also lasts about 2 hours, so I could use that in the same way.
2 hours? What books...
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 18, 2012 at 1:55 pm
Usually you'd use an audit and/or logging table to move deletions over. SCDs can't autodetect removed information. Trigger your deletions to an audit table and create a separate...
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 12, 2012 at 1:01 pm
10e5x (12/10/2012)
Hi Kraig,i want to be sure before approaching my boss. http://www.mssqltips.com/sqlservertip/2005/how-to-use-ssis-package-as-a-data-source-for-sql-server-reporting-services-2008-r2/
Oh lord, that.
Alright, yes. You can use SSIS as a data source for a Report. It's 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 12, 2012 at 12:43 pm
Fal (12/12/2012)
"This refers to how intense romantic scenes are in a story and how intense the sexual tension is between...
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 12, 2012 at 12:37 pm
+1 Chris. Another option is to not store the connection information in the package and set it up as a configuration, so if it ever changes you merely need...
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 10, 2012 at 3:28 pm
Viewing 15 posts - 916 through 930 (of 5,678 total)