Viewing 15 posts - 1 through 15 (of 18 total)
I made a SSIS package successfully by using the method in the artical:
http://www.simple-talk.com/community/blogs/jonathanallen/archive/2010/09/07/94303.aspx
I never try it from Excel to SQL server but hope it will work.
December 13, 2010 at 1:21 pm
Looking for this for a while..thanks!
December 8, 2010 at 2:02 pm
In my case, which is a SQL2008 R2, I successfully shrank the tempdb by using Method 1 in MS KB
http://support.microsoft.com/kb/307487
A little bit tricky part is I didn't logon by using...
December 7, 2010 at 11:15 am
Remove indexes before insertion, then recreate indexes.
November 26, 2010 at 9:20 am
Gianni Ottimista (11/25/2010)
I'va a Linked Server from SQL server 2005 to Oracle.
The big problem is the running query time: very very slow with four name way... ( select from two...
November 26, 2010 at 9:18 am
Thank you Steve. This is exactly what I want to know.
Regards
October 6, 2009 at 9:38 am
I did it like this:
Define a calculation item [Avg Discount]:
iif(IsEmpty([measures].[Qty]), NULL, 100 - (100*iif([Measures].[Amount]<0, -[Measures].[Amount], [Measures].[Amount]))/([Measures].[Qty]*[Measures].[Avg Rate]))
July 23, 2009 at 2:27 pm
Not sure this is your case but I solve this issue by using calculations on the cube. For example:
Year Quarter Discount% ...
July 8, 2009 at 9:51 am
Did anybody try this?
July 8, 2009 at 9:35 am
You can download OWC from Microsoft website. That's an Office add-on. It looks like exactly the same in visual studio when you browse your cube.
November 3, 2008 at 9:52 am
sujith (11/3/2008)
I installed both these dlls. Still I'm getting the same error.Do i need to register these??
Does the user have OWC (Office Web Component) installed?
November 3, 2008 at 8:12 am
what's your IIS authentication settings? You should only set the "Intergrated Windows Authentication" when you deploy your report. After deploying, then check the "Anonymous access", by using this you can...
July 11, 2008 at 11:43 am
I installed it on the end user's box.
July 3, 2008 at 8:29 am
singhs2 (6/25/2008)
June 25, 2008 at 1:38 pm
not sure if it is the exact what you want, but I answer your question in your another thread
June 25, 2008 at 8:55 am
Viewing 15 posts - 1 through 15 (of 18 total)