Viewing 15 posts - 271 through 285 (of 806 total)
What makes you say it is not growing? Any errors?
SQL will grow a file to a certain size and you will see the MDF will be 5MB, even though the...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 8, 2007 at 1:41 am
Table variables do harden to disk in tempDB if they get over a certain size.
They also get dropped after the spid is done executing.
if your TempDB is growing, but when...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 7, 2007 at 10:02 am
Rather store as XML, not varchar.
Read BOL! There are plenty examples on how to manipulate XML.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a699d976-8099-4af1-a2f8-cd0e2bd57a83.htm
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 7, 2007 at 9:51 am
Firstly, why are you storing it as a number? Why not store it the correct way and format ini the end app???
Why store it as a string?
If you must...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 7, 2007 at 9:49 am
is SQL actually running? Can you connect through SSMS?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 7, 2007 at 9:45 am
A very common issue and a painfuly boring one. It's to do with quotes in your paramters being pasted.
I would suggest, rather than passing them in, rather use a...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 7, 2007 at 9:41 am
if you create a script task or component, you should create a custom component for reuse. Faster, better, neater, easier to deploy etc.
I am not sure you could, or it...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 7, 2007 at 9:35 am
Interesting. I cannot see how the error is actually related to your SSIS package though. When SSIS runs, it does not hold many connections open. Only as many as there...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 7, 2007 at 1:31 am
There's nothing that I know of that documents a SSIS package. I know there were rumours of MS giving us something like that.
You could write an app to read the...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 7, 2007 at 1:28 am
I assume you are talking about DTS and not SSIS. This is a SSIS forum. You'd be better off posting in the DTS forum.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 7, 2007 at 1:26 am
Then your lookup would use a query Select Max(Col1) as Col1, Col2... Group By Col2.
You would then join that onto your source data.
BTW: Post the error. Not much point in...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 6, 2007 at 9:22 am
If I understand you, you want to save a dataflow with the basics in it for reuse? No, it was requested but is not implimented. Would be a nice feature.
Katmai is...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 6, 2007 at 9:14 am
How are you using a lookup to find the max? Why not use the aggrigate component?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 6, 2007 at 9:12 am
What is the error? Can you not cast the date time to something along the lines of '1 Jan 2000 10:01:01:000' and do a convert
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 6, 2007 at 9:10 am
Use Sum(Case when x=y then 1 else 0 End) as xxx
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 6, 2007 at 8:26 am
Viewing 15 posts - 271 through 285 (of 806 total)