Viewing 15 posts - 4,741 through 4,755 (of 5,678 total)
That's hashed, encrypted, or proprietary... and rather wild. FLOAT?!
Any chance you can share the name of the software?
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 3, 2010 at 2:45 pm
Anyone with some SSIS/flatfile export experience help me out at this thread, please?
http://www.sqlservercentral.com/Forums/Topic1030096-148-1.aspx
sjimmo and I have been going back and forth about workarounds but we're apparently missing the main question,...
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 3, 2010 at 2:43 pm
Ah, that helped cure my confusion. I apparently just can't read. I was, for some reason, trying to get multiple events out of the structure. :hehe:
What you've...
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 3, 2010 at 1:51 pm
sjimmo (12/3/2010)
Convert the file before SSIS uses it.
I'm sorry, but apparently I'm not being clear enough here. There is no flatfile before SSIS uses it. SSIS creates it.
I...
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 3, 2010 at 1:38 pm
I goofed off with this but the data layout seems a little strange to me, it may just be some internal assumptions I'm making about the data.
Any chance you can...
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 3, 2010 at 1:36 pm
sjimmo (12/3/2010)
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 3, 2010 at 1:30 pm
I found *a* solution, but it's a bad one from my perspective. I've created a computed column with "/r/n" in the expression and linked that into the final result...
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 3, 2010 at 12:55 pm
If I understood this correctly, you're basically just starting to use SSIS at all, and you need a beginner's guide.
Create some sources at the bottom, connecting to the different database....
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 3, 2010 at 11:10 am
Sorry, got distracted:
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
JOIN sysindexes AS i ON i.id = t.object_id
WHERE c.name LIKE '%n%'
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 3, 2010 at 10:59 am
join to sysindexes on indexID IN ( 0, 1) and check the row column.
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 2, 2010 at 3:01 pm
There's no quick and clean way.
One method is to do a select into a temp table for just the sorted columns with an IDENTITY() field, to find your...
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 2, 2010 at 2:59 pm
Tara-1044200 (12/2/2010)
so can i assume for SURE that someone else who has access has stopped it, if so how can i prove that?fyi..4 people has admin access on this box.
Without...
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 2, 2010 at 1:45 pm
nzrdb6 (12/2/2010)
there is a firewall between London and Berlin. What must I ask my...
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 2, 2010 at 1:44 pm
Phil Parkin (12/2/2010)
Craig Farrell (12/2/2010)
LutzM (12/2/2010)
You'd basically use a script component after...
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 2, 2010 at 12:38 pm
Tara-1044200 (12/2/2010)
SQL Server is terminating in response to a 'stop' request from Service Control...
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 2, 2010 at 12:36 pm
Viewing 15 posts - 4,741 through 4,755 (of 5,678 total)