Viewing 15 posts - 10,276 through 10,290 (of 11,676 total)
Steve Jones - SSC Editor (1/31/2011)
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. 🙂
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...
January 31, 2011 at 7:51 am
Grant Fritchey (1/31/2011)
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...
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...
January 31, 2011 at 5:23 am
For the moment:
Heaven nor Hell - Volbeat (some Danish rockband)
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...
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...
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.
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...
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...
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...
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...
January 31, 2011 at 1:14 am
Viewing 15 posts - 10,276 through 10,290 (of 11,676 total)