Viewing 15 posts - 7,816 through 7,830 (of 11,677 total)
1. Which version of Excel are you using? There are 64-bit providers available for the ACE OLE DB provider.
2. Do you get the error in BIDS or at server? The...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 11:37 pm
I think license-wise this could be a problem, as the developer edition is not allowed to be used in a production environment.
Furthermore, developer edition is capable of certain features that...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 11:34 pm
Apparently an expression for the textbox help_text evaluated to NULL.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 11:32 pm
Quite easy, as the question on 7 February asked which role was the least privileged 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 11:27 pm
Allright, you have an Excel file with 3 sheets.
You plan to loop over these sheets using a For Each Loop and a variable.
How are you going to put the names...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 11:12 pm
agg_rakesh (2/27/2012)
This really worked perfectly as i was looking for.Now the data type is always coming as nvarchar as i wanted.
Thanks for the solution.
No problem, glad to help.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 11:42 am
CozyRoc (2/27/2012)
In that case, there is a solution but it is a third-party commercial solution....
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 11:41 am
GSquared (2/27/2012)
Looks like yet another exam/interview sit to me.
This one obviously is (on another site):
I especially like:
<his e-mailaddress> pls send these questions with answers and u r friend
I wonder...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 7:13 am
It's not available in SSRS:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 5:48 am
Duran (2/27/2012)
Yes, you cant not make an appointment. Had E-mail confirmation, the lot. Rang the test centre number as well, but got answer because obviously nobody was there.D.
Show them the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 3:17 am
Duran (2/27/2012)
I have been studying for a few months for the 70-448 exam, in the last week I was cramming well into the early hours for last Saturdays exam,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 3:11 am
chaithu559 (2/27/2012)
Hi ,I store sheet names in variable whose scope is at level. I have initilized the first sheet name to the variable.
That's where you...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 1:49 am
Robert Davis (2/27/2012)
Koen, the program has been scaled out. Take a look here: http://www.microsoft.com/learning/en/us/certification/master-sql-path.aspx
So only 1 in Europe (if you do not count the UK) 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 1:31 am
Congrats Uwe! And thanks for sharing your story.
I didn't know you could take MCM in Europe. I thought it could only be taken in the U.S. (apparently some myth)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 1:06 am
Read through this MSDN article. You probably don't have DCOM security privileges on that server.
Connecting to a Remote Integration Services Server
Especially read the Eliminating the "Access Is Denied" Error section...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 12:54 am
Viewing 15 posts - 7,816 through 7,830 (of 11,677 total)