Viewing 15 posts - 8,461 through 8,475 (of 9,715 total)
DAMN!
It didn't completely work. Now it's padding the flat file with two SPACES after each dollar amount and truncating 2 zeros off the front of the fields.
GRRR.
EDIT: DOH! When I...
February 19, 2009 at 12:33 pm
WOW!
That was beyond complicated.
Here's what I did:
Changed the Output metadata column to decimal with a scale of 2. (Yes, I still had to do that).
Add 2 Derived Column transformations instead...
February 19, 2009 at 12:18 pm
Hmm. Now that's something I hadn't thought about.
When I tried this idea, I ended up, yet again, with 2 extra zeros at the end, but I can get around...
February 19, 2009 at 11:34 am
Right. I got that part.
The question is, what did he do after he found that information? How did he fix the "0" problem?
February 19, 2009 at 4:01 am
Thanks for posting in such detail! That will help others.
February 19, 2009 at 4:00 am
How did he fix the index problem?
February 17, 2009 at 5:30 am
What service pack are you on?
And have you tried searching TechNet to see if there's an existing bug yet?
February 17, 2009 at 4:30 am
sunny1_liu (2/16/2009)
But in my opinion, profiler may consume many system resources, so we hardly turn it on unless really necessary.
If you do profiler right, it won't consume as many resources...
February 17, 2009 at 4:23 am
Try switching the Model DB back to FULL recovery for a moment, backing up the transaction log, then switching Model back to SIMPLE. Then see if you can add the...
February 16, 2009 at 7:41 am
Granting references to DBO schema will indeed grant the ability to see the definitions to all DBO objects in that specific database. And remember, DBO doesn't own all schemas unless...
February 16, 2009 at 6:38 am
Your supplier's response still doesn't make sense to me. I can see granting reference to the defined user datatypes in the specific supplier's database, but not in TempDB.
I take...
February 16, 2009 at 6:26 am
BTW, as TempDB is essentially recreated every time you restart the services, what user defined datatypes are going to exist in it?
Does your supplier actually have code modifying TempDB?
That...
February 16, 2009 at 6:09 am
Have you checked the drive the transaction logs are on to make sure it isn't full?
Are you backing up your transaction logs (and checkpointing / truncating them) on a regular...
February 16, 2009 at 6:02 am
Question, what drive(s) are your system DBs on?
Also, does your Model db have a max file size?
Is your TempDB maxed out when you try this?
EDIT: I should clarify why I'm...
February 16, 2009 at 5:37 am
Sounds like you need to run Profiler when you run this job so you can track down exactly where the problem occurs. I'm betting your job gets suspended in the...
February 16, 2009 at 5:35 am
Viewing 15 posts - 8,461 through 8,475 (of 9,715 total)