Post reply

ssis and ssrs interview questions

  • December 23, 2008 at 12:52 am

    #916599

    Any one can tell. what ia a breakpoint in ssis? How is it setup? How do you disable?

  • December 23, 2008 at 1:03 am

    #916603

    jmohan_it (12/23/2008)

    Any one can tell. what ia a breakpoint in ssis? How is it setup? How do you disable?

    Have you looked through Books Online, specifically the sections on SSIS?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 24, 2008 at 10:58 am

    #917503

    Can you rollback a transaction on SSIS? Explain step by step how?

  • December 27, 2008 at 2:57 am

    #917995

    GilaMonster (12/23/2008)

    Have you looked through Books Online, specifically the sections on SSIS?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 25, 2009 at 1:38 pm

    #932432

    thank u vishal will u also post some interview questions regarding ssrs & ssas...

  • February 3, 2009 at 9:25 am

    #937251

    Thanks Vishal

  • February 3, 2009 at 9:50 am

    #937274

    I would like to point out that memorizing the answers to some probable interview questions is probably a good way to get job that you can't do and will be fired from. Don't interview for a job that you can't do. It hurts the company, which means it hurts all the other employees, if you get a job that way. It's dishonest.

    If that's not what's being done here, sorry. It's certainly what this thread looks like.

    Think of it this way: How would you feel if you found out your doctor got his job by memorizing answers to interview questions, but had no real knowledge of medicine?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • March 5, 2009 at 1:43 pm

    #954362

    Thanks a lot Vishal...tht was helpful...

  • March 5, 2009 at 2:18 pm

    #954414

    More questions (detailed)

    http://www.dotnetspider.com/forum/158771-Sql-Server-Integration-services-Interview-questions.aspx

  • March 5, 2009 at 8:01 pm

    #954609

    Is this really how people prep for job interviews these days?

    If so, could someone point me toward a list of interview questions for neurosurgeons. Might as well aim high.

    Tim Mitchell
    TimMitchell.net | @tmitch.net | Tyleris.com
    ETL Best Practices

  • April 13, 2009 at 1:12 pm

    #976837

    Well said. But some how, I use to look interview questions to gain more knowledge.

  • April 14, 2009 at 7:54 am

    #977222

    I bet these questioins help only land u in job, but day 1 u will see new posts from all these ppl

    🙂

    good intentions to help. But ppl; practice scenarios.....its not just q and a.

  • April 17, 2009 at 4:27 am

    #979526

    What are some of the Reporting Services best practices that you follow?

    Report Property options:

    SnapToGrid - For finer control of object sizes, set the SnapToGrid property to False. Once done, you can resize rows, columns, textboxes, etc. to more exact dimensions.

    InteractiveSize – To achieve one long scrollable web page, change height property (expanc InteractiveSize) to 0. Note: With reports that are very long, this can adversely affect report rendering times. Experiment, use judgement, and obtain feedback from users. Educate your users as to the pros and cons of this.

    PageSize – The default is 8.5in, 11in. This is a standard portrait letter size page size. For landscape printing, swap the width and height (to 11in, 8.5in). Coordinate these changes with the InteractiveSize. (i.e. If you want to print landscape, but see one long scrollable page in the web browser before printing, set the InteractiveSize to a width of 11in, and a height of 0.)

    Description – With Reporting Services (RS) in Native mode (not Sharepoint Integration mode), text you write in this property is displayed in the Report Manager and the WSS2 Reporting Services report viewer web part. For RS in Sharepoint Integration mode the entry has no affect. (For Sharepoint Integrated installations, you can add a field to the reporting document library and put the description there.)

    Table properties:

    DataSetName – Got have one, even if you are doing something creative like displaying some sort of header table. Almost every report I create has a dataset called ‘header’. I use this with a table to display the report logo graphic and some identifying fields (i.e. report runtime, username, report title, etc). This dataset is just a placeholder without any real content. Sometimes I use select statements like “Select getdate()” or “Select 1”.

    NoRows – Depending on data selection criteria and/or parameters chosen by users, your report may yield no results (no rows). (Or your backend server might be down…yikes!) This option allows you to display a custom message to users in the event there is no data to display. (i.e. “The parameters you chose contains no data…please change your parameter choices and try rerunning the report”.)

    FixedHeader – Set to “True”, this is the same as the “Header should remain visible while scrolling” checkbox in the Table Properties pop up window. It’s really a slick feature.

    Textbox properties within a table:

    BackgroundColor – Background color of the textbox

    BorderStyle – I prefer “Solid” most of the time

    Color – Means font color

    Format – Used for various number, percentage, date, text formatting. For Dates without time use ‘d’. For integers, use ‘N0’. For fixed decimals use N and then a number. ‘N4’ is a number with 4 decimals. Use ‘P1’ for a percentage with 1 decimal place. Check BOL for more formatting codes.

    Visibility – Another favorite, but deserves it’s own tip. Another day…

    CanGrow – ‘True’ most of the time, but I like to use ‘False’ if I don’t want lines to wrap. In that event, I add the field to the Tooltip in the properties window of the textbox.

    In the Properties section:

    RepeatOnNewPage – Does what it implies.

    Visibity – Use for drill downs.

  • May 20, 2009 at 1:51 pm

    #997868

    Thanks a lot mate.... for the interview questions

    Do you have any exercises which i can practice on SSRS/SSIS, thnx in advance..

    libra_jsb8@yahoo.com you can send them or links thnx agn

  • June 17, 2009 at 2:05 am

    #1010685

    Thank you vishal

    For SSIS interview Question

Viewing 15 posts - 16 through 30 (of 163 total)

You must be logged in to reply to this topic. Login to reply