Forum Replies Created

Viewing 15 posts - 10,276 through 10,290 (of 11,678 total)

  • RE: MS certification exams

    I believe you can't check those things on the website. Maybe if you call customer support?

    If you book your exam, at the last step when you enter your details, you...

  • RE: Are the posted questions getting worse?

    WayneS (1/31/2011)


    I've used ERwin and PowerDesigner in the past. IMHO, ERwin is too overpriced.

    I've also used both before.

    ERwin --> really didn't like it. It generated some change scripts to synchronize...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/31/2011)


    We had a deployment early am today, UK time, so there was some downtime there. Should have pointed to a maintenance page on this same...

  • RE: SQLCLR

    Nice question, thanks.

    A bit easy though, as you can guess the answer just by looking at the names of the DMV. 🙂

  • RE: Generate Excel File after Data Extraction

    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...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/31/2011)


    I was bad. I was very bad. Just had to slap down a poster, couldn't help it. "Hey, I need a complete system design, thanks." Man I hate...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/31/2011)


    Koen (da-zero) (1/31/2011)


    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...

  • RE: Are you a "hunt and pecker" or a "typist"?

    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...

  • RE: Today's Random Song!

    For the moment:

    Heaven nor Hell - Volbeat (some Danish rockband)

  • RE: How many of you are not true DBA's?

    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...

  • RE: Execution SQL task Connection Type issue

    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...

  • RE: Are the posted questions getting worse?

    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.

  • RE: FileSystemTask - move very slow to move 7 GB files?!!

    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...

  • RE: how to create dimension in ssas cube using ssis

    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...

  • RE: Generate Excel File after Data Extraction

    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...

Viewing 15 posts - 10,276 through 10,290 (of 11,678 total)