Viewing 15 posts - 271 through 285 (of 805 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...
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...
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
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...
August 7, 2007 at 9:49 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...
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...
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...
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...
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.
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...
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...
August 6, 2007 at 9:14 am
How are you using a lookup to find the max? Why not use the aggrigate component?
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
August 6, 2007 at 9:10 am
Viewing 15 posts - 271 through 285 (of 805 total)