Viewing 15 posts - 9,151 through 9,165 (of 9,715 total)
I'm going to have to get back to you on the "permit in database role" stuff for SA, but I wanted to mention something to you about your last post.
If...
January 11, 2008 at 12:43 pm
I did actually have the subreport parameterized, but maybe I set it up wrong. Thanks, Matt. I'll look into it.
January 11, 2008 at 10:09 am
What it means is they've packaged their datafixes in an .msi or something similar which has the SA account hardcoded into it and it just prompts for a password.
I've seen...
January 11, 2008 at 10:07 am
Matt,
I'm not sure Rollup is going to work with this. The detail takes the PaidAmt and divides it by #Claims. I'm not quite sure what the load process...
January 11, 2008 at 8:10 am
I'm thinking about this report and-ideally-here's what I'd like to do.
Have 2 datasets. DataSet1 is the detail. DataSet2 is the totals.
Write some sort of expression or code where...
January 11, 2008 at 7:21 am
You also need to discuss with your contractee how often you plan to invoice them and how long they have to pay you. This is VERY IMPORTANT. If...
January 11, 2008 at 6:07 am
Unfortunately, you can't just not use SQL Server every day. You have to make time. Schedule yourself during lunch or an hour before / after work and use...
January 11, 2008 at 6:03 am
Jack & Matt,
You were both right. Non-numeric empty string that I couldn't fix on the query side. Had to mask it in the report.
Thanks to both of you...
January 10, 2008 at 11:25 am
Gosh darnit! I had multiple windows open this morning and thought I put this one in the SSRS forum. Sorry all.
But I'll take Matt's suggestion and see if...
January 10, 2008 at 10:55 am
You might be stuck with making the DBA of the other database export the data as a flat file and then hooking up with that.
But I'm positive I read...
January 10, 2008 at 10:11 am
That's not what I meant. I only ever use the OLE DB sources and destinations. Hence, I don't know the trick (and there is one, I remember seeing...
January 10, 2008 at 8:42 am
Technically, nothing should be using the SA account. If you have jobs, processes, users or anything else using the SA account, you've already got a serious security problem.
SA should...
January 10, 2008 at 8:26 am
And once the email goes out, even if it's only to legit business users, it only takes one "blonde moment" to forward the email to someone outside of the business,...
January 10, 2008 at 8:14 am
I always use OLE DB sources, so I really can't answer that question for you. Has anyone else done ODBC sources?
I recommend the SSIS book put out by McGraw...
January 10, 2008 at 8:03 am
What you need to do next is add a data flow task to the control Flow. Data flow should be in the Toolbox. Add that, double-click the icon,...
January 10, 2008 at 7:29 am
Viewing 15 posts - 9,151 through 9,165 (of 9,715 total)