Viewing 15 posts - 10,276 through 10,290 (of 11,676 total)
Steve Jones - SSC Editor (1/31/2011)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 1, 2011 at 12:13 am
Nice question, thanks.
A bit easy though, as you can guess the answer just by looking at the names of the DMV. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 1, 2011 at 12:08 am
Little Nick (1/31/2011)
Marco Terzolo (1/31/2011)
DECLARE @strsql NVARCHAR(255)set @strsql='namefile.xls'
EXEC sp_makewebtask
@outputfile =@strsql,
@query = 'Select * from View1',
@colheaders =1,
@FixedFont=0,@lastupdated=0,@resultstitle='objecttitle:'
I hope you can explain line by line. I'm too junior...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 7:51 am
Grant Fritchey (1/31/2011)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 7:02 am
Brandie Tarvin (1/31/2011)
Koen (da-zero) (1/31/2011)
I can browse through the forums, but if I want to go to the home page, I get a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 5:25 am
I was a hunt and pecker when I was a kid, but I followed a course at school and now I'm a proud typist 🙂
However, in my country we use...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 5:23 am
For the moment:
Heaven nor Hell - Volbeat (some Danish rockband)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 5:17 am
I'm a Microsoft BI developer (mainly SSIS), but I like to have some foundation of TSQL and SQL Server in general, as it really helps in making more efficient SSIS...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 5:16 am
How did you set-up the configuration?
Did you use an XML config file?
Can you explain exactly what you have done to set-up the connection manager's configuration. This way it will be...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 5:07 am
Does anyone else have problems surfing the site?
I can browse through the forums, but if I want to go to the home page, I get a Maintenance page.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 5:05 am
Is it an option to create a windows batch file to copy the files?
SSIS is an ETL tool, I think there are better options to just move files from one...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 1:21 am
miriyalasrihari (1/31/2011)
how to create dimension in ssas cube using ssis?
You create a table in the database and you populate it with data using SSIS.
You open your cube, and in the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 1:18 am
Little Nick (1/30/2011)
I intent to perform SSIS.Once extract is successful. How to generate Excel file into specific folder?
Do you mean creating a new Excel file?
A script task should be able...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 1:17 am
There is nothing wrong with preparing yourself for an interview (you should be), but in my opinion, not knowing all the answers is not that bad.
If you can show the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2011 at 1:14 am
Well, this was an easy one 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2011 at 11:49 pm
Viewing 15 posts - 10,276 through 10,290 (of 11,676 total)