Search Results: detail

• 
  SSIS: How to know/log each step duration and errors (inside DTS with Logging)

  In my previous post, I've shown how you could extract the time duration of a DTS. Assuming that you have selected the DTS witch is the slowest among the others, how could you know wich of the steps is the worst? Imagine that you have 20 steps inside the D

  Author:  marcoadf     Date: 1/30/2010     Section: Blog

  tags : DTS, Event, File Connection, Logging, OnProgress, Progress, SSIS
• 
  SSRS: Click Through / Drill Through / Action to go to another report

  Today in class I was asked a very interesting question. One of the attendees asked if SSRS 2008 was limited to a specific number of drill through's in a report. At the time, I created a report, that enabled the end user to click on the Reseller Name and g

  Author:  SMcDonald     Date: 4/13/2011     Section: Blog

  tags : Action to go to another r, Click Through, Drill Through, Reporting Services, SSRS, Sherri McDonald
• 
  Programmatically Import Flat File Data Source into SQL Server 2008 Using SSIS’s Script Task Tool

  This article demonstrates creating a SQL Server Integration Services package that imports a text file into SQL Server database table using a Script Task component

  Author:  mafiswana     Date: 3/25/2012     Section: Article

  tags : C#, create package, C-Sharp, Data Flow Task, dynamic, Flat File, OLE DB, OLE DB Destination, package, programmatic, script task, SQL Server, SQL Server 2008, SQL Server Intergration Services, SSIS, SSIS package, Text File
• 
  SQL Server “Denali”: Details on the next version of SSAS

  At the recent TechEd North America 2011 conference, details on the next version of SQL Server called “Denali” were released. Part of those details were an update on the SQL Server Analysis Services ( SSAS ) roadmap. The main new feature in SSAS is a new d

  Author:  jamserra     Date: 6/29/2011     Section: Blog

  tags : Denali, SQL Server, SSAS, BISM
• 
  Get Index Details

  We all know that indexes on tables help performance. However, sometimes too much indexing could affect performance as well. One way to see some details of indexes for a table is by querying the sys.dm_db_partition_stats and the sys.indexes table. As you c

  Author:  briankmcdonald     Date: 6/7/2010     Section: Blog

  tags : Index Details, SQL Server, TSQL
• 
  Rock Your Reports Series 3 of 3

  In this series finale, Sherri McDonald will show you to create a drill through from 1 map report into a detailed report for the state as well as include a map of the state.

  Author:  SMcDonald     Date: 3/28/2011     Section: Article

  tags : Maps, Pragmatic Works, Reporting Services R2, Spatial data, SSRS R2, Sherri McDonald
• 
  Free Business Intelligence Workshop

  If you are in and around Dallas next week drop by my FREE half-day Business Intelligence workshop. The details are below: Unlock your Data with the Microsoft Business Intelligence Platform Event Details: November 8, 2011 Registration at 8:00am Microsoft O

  Author:  PatrickLeBlanc     Date: 11/1/2011     Section: Blog

  tags : Project Crescent
• 
  Hiding reports in SSRS

  Here’s another quick tip when working with SSRS. You recently have been creating a lot of new reports for your company and while all of the reports are necessary for the company they don’t like how cluttered everything looks in the report manager. In this

  Author:  ChrisAlbrektson     Date: 8/17/2010     Section: Blog

  tags : Hide in tile view, ssrs, Hide
• 
  Getting Started with Microsoft Data Explorer

  What is Data Explorer Data Explorer simplifies the data discovery phase for Excel users that are creating self-service Business Intelligence solutions. It does this by provided straightforward methods for connecting to data previously unheard of, without

  Author:  DevinKnight     Date: 3/6/2013     Section: Blog

  tags : Data Explorer PowerPivot, Excel 2013, Power View
• 
  Action Packed Maps in Your Reports

  A couple weeks ago I went over some tips for customizing your maps in Reporting Services 2008 R2. This week I'm going to stay on the same topic, but instead of customizing your legend ranges , I thought I'd go over a pretty cool interactive option that is

  Author:  kylewalker     Date: 3/31/2011     Section: Blog

  tags : maps, MDX, report actions, SSRS
• 
  Speaking at the SQL Lunch UK

  Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change. Unlike the SQL Lunch that I host online here in the U.S., the SQL Lunch UK , which is hosted by Dave Bally (@davebally), will be held at a physical location. Well exce

  Author:  PatrickLeBlanc     Date: 2/24/2012     Section: Blog

  tags : AlwaysOn, Speaking, SQL Lunch, SQL Lunch UK
• 
  Assistance Needed in Correctly Scoping a SSRS 2005 Calculation

  For this particular instance, it does not look like you need to use InScope. Correct me if I am wrong here. In the example that you provided in the word document. You refer to 682 RENAL FAILURE W MMC. There are 5 total encounters, 5.10 Geometric Length of

  Author:  briankmcdonald     Date: 6/30/2011     Section: Forum

  tags : Brian K. McDonald, ReportItems, SQLBIGeek, SSRS
• 
  SSRS 2008 R2 June Webinar Details

  Today I gave a presentation on how to create some awesome reports using the Sparkline, Map and Data Bar (all R2 features). I also discussed some of the different areas you could use expressions and showed some different examples. I am really excited that

  Author:  SMcDonald     Date: 7/1/2011     Section: Blog

  tags : Databars, Maps, Pragmatic Works, Sparklines, SSRS, SSRS 2008R2, Training on the T's, Sherri McDonald
• 
  Because the Fortune Cookie tells me to use Configuration Files!

  If you have ever developed SSIS packages that would eventually be deployed to a production environment then you've run into this issue. I'm talking about Package Protection Levels. What tends to happen is users set up their packages how they want them, th

  Author:  Tyler     Date: 11/18/2011     Section: Blog

  tags : config, configuration, Deployment, errors, Files, Package Configurations, validation
• 
  SQL University: Architecture for Small Businesses

  Welcome back to SQL University! This week we’re going to be discussing architecture. In previous weeks we’ve discussed architecture at a high level ( Capacity Planning Week ) but this week we’re going to get a little more focused. SQL Se

  Author:  sqlchicken     Date: 9/19/2011     Section: Blog

  tags : administration, Architecture, azure, Cloud Computing, Licensing, SQL Azure, sql university, sqlu
• 
  SSRS Self Referencing Drill Through

  When looking at a report and wanting to drill through to get more detail, we often create two reports for this. This can be accomplished by just one report by creating a self-referencing action that links to the same report. This can be done even if the r

  Author:  MikeDavis     Date: 10/19/2010     Section: Blog

  tags : Action, Drill Down, Drill Through, SSRS
• 
  Combining Fields

  You say: "I have a report built and it has groups. On some reports under the last group (in the design mode) there is a details group. I can not figure out how to get that on all reports if I want it. " Usually when I build reports I build them from the d

  Author:  Daniel     Date: 3/18/2011     Section: Forum
• 
  One last day in the Foundation Class

  As some of you may know, I work for Pragmatic Works. Not only are we already an awesome company to work for, but something else that is pretty fantastic is give away a free week of BI training. This training is given to people who have served in the milit

  Author:  SMcDonald     Date: 3/3/2011     Section: Blog

  tags : Foundation, Free BI Training, Pragmatic Works, Reporting Services, SSRS, TSQL, Sherri McDonald
• 
  Passing a parameter from a summary report to a detail report using SSAS as a source

  Hi, I am trying to pass a parameter from a summary report to a detail report and my data source is SSAS. I am using SQL Server 2008. On my summary report, I have set an action on a text placeholder properties to go to my detail report. On my detail report

  Author:  informationiq     Date: 8/16/2010     Section: Forum
• 
  Download all SQL Server DENALI CTP3 Demo VHD 36 files at once

  Microsoft has made available for download the SQL Server DENALI CTP3 Demo VHD several weeks ago at http://www.microsoft.com/download/en/details.aspx?id=27740 . The SQL Server DENALI CTP3 Demo VHD is a fully configured HyperV image of SQL Server Denali CTP

  Author:  JoseChinchilla_SQLJoe     Date: 9/25/2011     Section: Blog

  tags : ctp3, Denali, sqlserver
• 
  Upcoming Community Events!

  Just a head's up. I've got a few speaking engagements coming up in the near future. Come out and join me at these fantastic free community events! 3/10/2012 - SQL Saturday #110 Tampa Introduction to Master Data Services 2012 More Info | Session Info 3/13/

  Author:  cprice1979     Date: 2/9/2012     Section: Blog

  tags : Compression, IT Pro Camp, PASS BI Virtual Chapter, SQL Saturday
• 
  Using Messages to Navigate in an MVVM Structure

  As a C# Noob, I've pretty much thrown myself in head first with my latest project. However, to do it right, I wanted to use the MVVM structure that's all the rage these days (and for good reason). I won't go into detail about what MVVM is, or why it can h

  Author:  RCharCox     Date: 2/21/2013     Section: Blog

  tags : C#, GalaSoft, MVVM, navigation, programming, XAML
• 
  24 Hours of PASS Recordings Available

  If you missed any of the great 24 hour of PASS sessions from September you can now watch the recordings. http://www.sqlpass.org/UserLogin.aspx?returnurl=%2fLearningCenter%2fSessionRecordings%2f24HoursFall2012.aspx Details on my session can be found below:

  Author:  DevinKnight     Date: 10/12/2012     Section: Blog

  tags : Speaking
• 
  merging data from two recordsets into one flat file

  I have an oleDBsource that pulls all the data i need (from a header table & detail table) going into a flat file destination with '~' as my separator. The output right now is: H ~headerColumn1~headerColumn2~headerColumn3~ D ~detailColumn1~detailColumn

  Author:  sherz1000     Date: 12/31/2009     Section: Forum
• 
  Report Headers

  This should be done thru the group header. Add the supplier as a group and then you can add multiple header lines for that single group by just grabbing the group header line on the left and copy and paste or right click the number at the left of the head

  Author:  MattDayton     Date: 6/8/2010     Section: Forum

  tags : format, Group, ssrs