Search Results: 2008

• 
  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
• 
  SSIS 2008 Logging and Package Configuration Objects FAQ

  SSIS 2008 Logging to SQL Server 1. Can I change the dbo.sp_ssis_addlogentry system stored procedure to non-system stored procedure and if so how is this done? Yes – you must drop and recreate the procedure (and don’t run [sp_MS_marksystemobject] N’[dbo].[

  Author:  JoeSalvatore     Date: 2/25/2011     Section: Blog

  tags : 2005, 2008, 2008 R2, Business Intelligen, SQL Server Versions, SSIS Integration Services, SQL Server
• 
  Upgrading from 2005 to 2008 (R2?)

  I'm looking at upgrading some ( 13 including my DR site ) servers from 2005 to 2008 or 2008 R2. I don't work for a huge shop ( in terms of SQL installations ). I support primarily 3rd party applications on the servers, an increasing number of in-house app

  Author:  KeithHyer     Date: 10/5/2010     Section: Forum

  tags : 2005, 2008, 2008 R2, reasons, upgrading
• 
  Intro to SSRS 2008 Webinar....We tell jokes....

  Intro to Sql Server Reporting Services 2008 Webinar On February 10th, I presented an Intro session for Reporting Services 2008. We had a great turnout with more than 330 people present. Some of the items that we learned about was: 1. Solutions can hold mu

  Author:  SMcDonald     Date: 2/11/2011     Section: Blog

  tags : Free SSRS Training, Intro to SSRS 2008, Pragmatic Works, SSRS 2008, Webinar, Sherri McDonald
• 
  BULK INSERT

  « 1| 2 | 3 » Recently, there was a post where the user found himself in a problem when loading data utilizing BULK INSERT This post is the first from a series, wich I want to explain how to use BULK INSERT in multiple possible ways. BULK INSER

  Author:  marcoadf     Date: 1/13/2012     Section: Blog

  tags : bulk, bulk insert, column, csv, fieldterminator, file, firstrow, flat, fmt, format, identity, identity column, insert, lastrow, rowterminator, Server, skip, txt, view
• 
  SQL Server 2008 R2 for the DBA Recording and PowerPoint

  I recently had the opportunity to do two presentation on SQL Server R2 for the DBA. In the first session there were approximately 150 attendees and at the second there were approximately 400 attendees. The recording is available here and you can download

  Author:  PatrickLeBlanc     Date: 7/23/2010     Section: Blog

  tags : Patrick LeBlanc, Speaking, SQL Server, R2
• 
  SSIS Data Flow task not running, but not failing

  Apologies for the ambiguous title, but was unsure how to headline this query. Windows Server 2008 (x86) with SQL Server 2008, posted images of the task operational details are below, but first a summary of the issue. I have a very straightforward data flo

  Author:  user730460     Date: 11/29/2011     Section: Forum

  tags : ADO.Net, data flow performance, ODBC, PI WADIS
• 
  Creating dimensions in SSAS 2005 and 2008 -- differences

  This article discusses the procedure to create dimensions in SAS 2005 and 2008. In both SSAS 2005 and 2008 we can create dimensions using wizards. The biggest difference is in 2005 the wizard asks lot more questions than in 2008. In 2008 the wizard is a l

  Author:  indupriya     Date: 7/6/2010     Section: Article

  tags : SSAS 2008, SSAS 2005
• 
  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
• 
  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
• 
  Rock Your Reports Series 1 of 3

  In this article, Sherri will show you how create a report that will utilize a your toolbox items from SSRS 2008 and SSRS 2008R2. Learn how to build the report with step by step instructions, including the query to pull the back the data. This is part 1 of

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

  tags : Charts, Indicators, Pragmatic Works, Reporting S, Rock your reports, SSRS, Webinars, Sherri McDonald
• 
  Creating 5 Star Rating using Indicators in SSRS 2008 R2

  Creating 5 Star Rating using Indicators in SSRS 2008 R2

  Author:  aseem.sb     Date: 1/3/2012     Section: Article

  tags : Indicators, Reporting Services 2008 R2, SSRS R2
• 
  SQL Server Agent - Creating an instance of COM component with CLSID

  Today, one of my team members faced an issue that I was not able to give the answer right away. The problem was, in SSMS while he was connected to DEV JOBs, he couldnt edit steps, as image below: First we started for privileges/permissions issue. But that

  Author:  marcoadf     Date: 1/25/2012     Section: Blog

  tags : @@version, 2008, Creating an instance of the COM component with CLSID, r2, Server, version
• 
  Useful queries #3: Get SQL Server Edition, Version, Build and Last Update date and time.

  Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don?t have the right tools and documentation. A very easy way to obtain version, edition and build information from your SQL Servers is by querying the SERVE

  Author:  JoseChinchilla_SQLJoe     Date: 10/11/2011     Section: Blog

  tags : build, cumulative, edition, editions, service pack, SQL Server, update
• 
  SSAS 2008 Bug: Normal Additive Measures and Semi Additive Measures in the Same Measure Group Don't Display Properly

  Devin Knight and I stumbled onto another weird SSAS bug today. We had a measure group that had two measures. The first measure was semi additive (Last Non Empty) and the second measure was a normal additive type (Sum). The additive measure would not displ

  Author:  DustinRyan     Date: 4/5/2011     Section: Blog

  tags : bug, error, SSAS 2008
• 
  Ole db destination from a sybase dsn source running slow in ssis 2008

  Prior to upgrading to SSIS 2008, I had a data warehouse that was populated by two separate processes, an SSIS 2005 package (populating one subset of tables) and an old vb.net application that populated the second subset of tables. Once I upgraded to SSIS

  Author:  griffster     Date: 2/22/2012     Section: Forum

  tags : ole db destination, ssis 2008, sybase odbc dsn
• 
  Report Services 2008 R2 - Data Bar

  In this article, you will learn how use the new data bar control in SQL Server Reporting Services 2008 R2 just released a few short weeks ago.

  Author:  briankmcdonald     Date: 5/26/2010     Section: Article

  tags : Data Bar, SSRS, Reporting Services 2008 R2
• 
  Upcoming SQL Events

  I realized this morning that I will be participating in three SQL Events this week and I want to share the event information with everyone. Two of the events are available online and the other is a local user group meeting. If you have time logon onto one

  Author:  PatrickLeBlanc     Date: 5/23/2010     Section: Blog

  tags : Baton Rouge SQL Server User Group, PASS, Patrick LeBlanc, Speaking, SQL Lunch, SQL Server Events
• 
  How can we know and free remote login session in Windows Server 2008 ?

  Through this post , I want to share about the problem we faced while working in Windows Server 2003/2008. In our day to day work , we might frequently need to connect to remote Windows Server machine and while we try to connect to the Windows Server which

  Author:  Anil     Date: 5 days ago     Section: Blog

  tags : Windows Server
• 
  open report in new window

  Hi, have a look here: http://www.bp-msbi.com/2008/09/advanced-javascript-in-reporting/ There is an example how to pass parameters to another to the new window... And if you want to have a kind of function, you can hava a look here: http://jochenj.wordpres

  Author:  BI-Tec     Date: 5/30/2012     Section: Forum

  tags : Custom Code, javascript, popup, ssrs function
• 
  Group Level Page Numbering using Reporting Services 2008 R2

  In this article, Brian will show you how to include group level page numbering along with total report page numbering. This comes in handy when you have a large report with sets of grouped data.

  Author:  briankmcdonald     Date: 12/15/2010     Section: Article

  tags : Brian K McDonald, Group Page Numbering, Page Numbering, ResetPageNumber, SSRS, Reporting Services
• 
  This Year - Last Year SSAS Calculated Member

  In this quick demo I’m going to add a calculated member to the AdventureWorks cube that allows an end user to do a This Year/ Last Year comparison for a given measure.

  Author:  tinocash     Date: 2/16/2010     Section: Article

  tags : Analysis Services, Calculated Measures, SSAS, Calculated Members
• 
  Is my SQL Server Pre-Release

  I get to work with a lot of different clients and client environments and like many companies they are often running mixed versions of SQL Server. This can make things challenges when doing training since if some folks are missing service packs, etc.. The

  Author:  AdamJorgensen     Date: 7/9/2010     Section: Blog

  tags : KBs, Versions, SQL Server
• 
  SSAS 2008 Storage Modes

  In SQL Server Analysis Services 2008, we have three storage mode options available to us: Relational Online Analytical Processing (ROLAP), Multidimensional Online Analytical Processing (MOLAP) and Hybrid Online Analytical Processing (HOLAP). There are adv

  Author:  DustinRyan     Date: 7/21/2010     Section: Blog

  tags : HOLAP, MOLAP, ROLAP vs. MOLAP, SSAS 2008 Storage Modes, ROLAP
• 
  Exploring Row and Page Compression with SQL 2008 - Part 2: The estimates

  Hopefully if you are reading this post, then you have already read PART 1 of this series. http://www.bidn.com/blogs/bretupdegraff/bidn-blog/263/exploring-row-and-page-compression-with-sql-2008-part-1-the-research In review, we are taking an 80 Gig data wa

  Author:  bretupdegraff     Date: 12/13/2009     Section: Blog

  tags : Compression, SQL 2008