BI Developer Network Community blogs

Who is online?  0 guests and 0 members
Home  »  Blogs  »  Blogs: April 2010

Communifire Blogs

Blogs RSS Feed

Blogs : April 2010 postings

timmurphy

Limit Recent Projects Appearing on Visual Studio Start Page

4/18/2010 by timmurphy  -  Comments: 0  -  Views: [2764]

I'm fairly new to Visual Studio so I like learning neat little "tricks" every now and then as I work with it. Here's a tip that might come in handy some time. If you have created a bunch of projects, say maybe for testing or something like that, you could end up with some of them listed on your Start Page. You may want to limit the number of recent projects that show up there. To do this, go to Options – Tools – Environment – General and under recent files put a number that corresponds to the nu...

Read More

DevinKnight

SQL Saturday #38 Jacksonville Update

4/15/2010 by DevinKnight  -  Comments: 0  -  Views: [1994]

With less than a month away, May 8, before the big event in Jacksonville I wanted to give you a little inside information about this event if you've never been to one before. SQL Saturday is a free training and networking event with Microsoft MVPs, SQL Server Authors and other professionals. If you are looking for great free training we will have six tracks for Beginners, Business Intelligence, DBA, and Developers. Take a look at the schedule here to see what interests you most! Notice one of th...

Read More

PatrickLeBlanc

Editing Saved Packages

4/15/2010 by PatrickLeBlanc  -  Comments: 4  -  Views: [7203]

During my last SQLLunch , Introduction to SSIS, I was asked an interesting question by one of the attendees. He asked, how do you edit a package once it’s saved in the SQL Server package store? My response was to open your SSIS project and edit the package from Business Intelligence Development Studio (BIDS). His response was, I did not save the project. Huh, what? That’s what I thought. He tried to explain further, but I did not quite understand. He said I will be at the user group on Wednesday...

Read More

indupriya

SQL Server 2008 R2 Training Kit

4/14/2010 by indupriya  -  Comments: 0  -  Views: [2587]

SQL Server 2008 R2 Training Kit New updated version of SQL Server 2008 R2 Training Kit is available for download from the microsoft site. This has some hands on labs, tutorials, presentations, and videos. Download from: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d Hope you will enjoy using this training kit.

Read More

MikeDavis

SSIS Bulk Insert Task Error File Not Found

4/14/2010 by MikeDavis  -  Comments: 0  -  Views: [8086]

When using the Bulk insert task in SSIS, you might encounter an error stating that The File Does Not Exist or The Path Specified Cannot be Found. This is usually due to the fact that the file must be on the same server as the database. In other words, it you are connecting to a remote machine the flat file must be on the remote machine. The connection to this file in the SSIS package must use a UNC path and not a mapped drive. If you are using the local instance of SQL server then the file conne...

Read More

kylewalker

Passing date parameters to DB2 in an OLE DB source

4/14/2010 by kylewalker  -  Comments: 0  -  Views: [13198]

As we found out from Devin Knight's blog, SSIS - Data Provider Does Not Allow Parameters in OLE DB Source , we know that we cannot pass any variables to DB2 in an OLE DB source. However, in the event that you need to pass date parameters to a data source, here is an example that is relatively easy to mimic and will only require the creation of one stored procedure in addition to some commonly used SSIS components. To add a date parameter that will pull back the last week's worth of sales data, y...

Read More

indupriya

Tools for collecting all the SLQ Server instances in your network

4/14/2010 by indupriya  -  Comments: 0  -  Views: [4843]

Due to the proliferation of personal firewalls, inconsistent network library configurations, and multiple-instance support, SQL Server installations are becoming increasingly difficult to discover, assess, and maintain. Peter Ward from WardyIT Solutions while presenting in the SQL Saturday event at Auckland last weekend has asked all of us the following question: “Do you know how many instances are there in your network?” Only two people in the entire room have raised their hands. He mentioned a...

Read More

indupriya

Recap from SQL Saturday in Auckland 10th April 2010

4/13/2010 by indupriya  -  Comments: 0  -  Views: [1288]

This past weekend I have attended the SQL Saturday event in Auckland The turnout for this event was really good with close to 100 people attending including the organizers and presenters. Thanks to everyone that helped out to put on a very successful event. Here is a list of the presenters and the topics presented. We had to cancel the main organizer’s (Dave Dustin) due to lack of time. Session Title My learning’s in brief Analysis Services - Introduction to Business Intelligence with SQL 2008 J...

Read More

SMcDonald

Syntax Error on an Expression

4/13/2010 by SMcDonald  -  Comments: 0  -  Views: [1305]

I recently came across an error after I copied some code (see below) and pasted it into a Expression Box. CASE Gender WHEN ‘M’ THEN ‘Male’ WHEN ‘F’ THEN ‘Female’ ELSE ‘Unknown’ END What I found out from Brad Schacht was the encoding on the single ticks is different in the SSIS environment from a Word Document. TO FIX IT: I had to delete each tick and replace it with a new one and was able to proceed. Want to know how to document/take a snapshot of your BIDS environment, click here . Need to migr...

Read More

chatakondu

BI xPress 2.2 launched

4/13/2010 by chatakondu  -  Comments: 0  -  Views: [1640]

Last week i have attended demo on BI xPress 2.2 launch which was organized by Pragmatic works and i would like to explain the auditing feature in detail. Auditing feature that they have in 2.2 is awesome feature since it captures the errors in detail including the diagram where it failed. Please see the attached screen shot which shows clearly whether the package is failed or successful. I had very hard time to identify the errors on package failures previously now i am sure this will solve my p...

Read More

DevinKnight

Reporting Services 2008 R2 Data Bars

4/13/2010 by DevinKnight  -  Comments: 1  -  Views: [26631]

Last week I wrote a blog explaining how the new tool inside Reporting Services 2008 R2 called Indicator will be help for displaying KPIs in Reporting Services. Today I want to looks at another nice feature added to Reporting Services in R2 called Data Bar. It’s a small but nice add to the product that gives it a little bit of an Excel look and feel. You may already know there is a nice but simply feature in Excel to help you compare data called Data Bars shown below, shown below. This same funct...

Read More

PatrickLeBlanc

Speaking Twice This Week

4/11/2010 by PatrickLeBlanc  -  Comments: 0  -  Views: [1401]

This week I will have the opportunity to speak at two different events. The first is on Monday, April 12 th , at the SQL Lunch . I will be doing an Introduction to SSIS presentation . The presentation is online and will begin at 11:30 AM CST. If you have time during lunch, please join me for a quick presentation on SSIS. On Wednesday, April 14 th , I will be speaking at the Baton Rouge SQL Server User group . I will be do a Backup and Data Compression presentation. If you are in or around Baton ...

Read More

jchacon

Reporting Services: Cube Report - Calendar Date Picker Parameter

4/10/2010 by jchacon  -  Comments: 1  -  Views: [25624]

The following summary details the steps to follow in order to implement a calendar date picker as a parameter of a cube report utilizing Visual Studio 2005 and SQL Server 2005 Service Pack 2 (with Analysis Services and Reporting Services). It is very important to keep in mind that there are several ways in which cubes store datetime fields. You need to mouse over the member to see the exact syntax of the member. One of the most common types is the following (string data type) format: Example: [D...

Read More

DevinKnight

Reporting Services 2008 R2 KPI ready

4/9/2010 by DevinKnight  -  Comments: 3  -  Views: [96259]

As I begin to explore more and more of the new feature that will be available in SQL Server 2008 R2 I can’t help but think why was this not available before? One of these features is the new item in the Reporting Services Toolbox called Indicator. It finally gives you a little help when it comes to displaying Analysis Services KPIs in a Reporting Services report. Before now you could display KPIs by importing your own image and writing some conditional expressions in the reporting expression lan...

Read More

timmurphy

Format a Number in SSRS with CStr and FormatNumber

4/7/2010 by timmurphy  -  Comments: 3  -  Views: [55213]

To make my client's report easier to understand it needed to display a calculated number followed by some text all within one cell. The CStr function was good enough to convert the number to text but the format of the number was not correct. A comma separator for the 1,000’s was needed. The FormatNumber function took care of this but I also had to include 0 for the NumDigitsAfterDecimal argument since this was a count. Optionally you could specify using parentheses for negative numbers and add l...

Read More

pwmkt2

Css Box Shadow Sample

4/7/2010 by pwmkt2  -  Comments: 0  -  Views: [3930]

.shadow { -moz-box-shadow: 3px 3px 4px #000; -webkit-box-shadow: 3px 3px 4px #000; box-shadow: 3px 3px 4px #000; }

Read More

BradSchacht

Open File - Security Warning in SSIS

4/7/2010 by BradSchacht  -  Comments: 0  -  Views: [6198]

When running packages that contain executable and batch files you may sometimes come across an issue where you need to confirm that you want to open the file. This can cause an issue if you run the package unattended. Obviously, this is a security precaution that is built into the many of the newer versions of windows. You have to authenticate sessions, run as administrator, and confirm that you want to open and run a file that could possibly pose a security risk. We know that we want this file ...

Read More

MikeDavis

XML Task in SSIS

4/6/2010 by MikeDavis  -  Comments: 3  -  Views: [44117]

The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML. In a previous blog I showed how to use a web service task to get the city and state when entering a zip code. You can view that blog here . The results we got back from the web service were in XML format and we saved them into a variable named Results. This image shows the value in the variable. We need to get the city and the state out of this XML and save them each into a variable. You will need to crea...

Read More

MikeDavis

SSIS Web Service Task

9/8/2011 by MikeDavis  -  Comments: 13  -  Views: [41170]

The Web Service task in SSIS can be used to call a web service command to perform a needed operation in your package. The results of most web services will be in XML Format. You can save these results into a variable or into a file. Either way, you can then parse the XML to find the node values you need. This can be done with the XML task in SSIS. Click here to see my blog on the XML task . The Web Service I am using is a free demo service. It allows you to enter a zip code and returns the city ...

Read More

nitya

Proxy

4/6/2010 by nitya  -  Comments: 0  -  Views: [1501]

There might be instances where you develop your packages to use Integrated security. After all the unit testing, you try run it in a SQL Agent job and it fails. The reason could be because you're running SQL Server Agent using local service account. Several times Corporate policy prevent yo from chaning the credential on which Agent runs. SQL 2005 onwards Microsoft introduced Proxies, where you can impersonate using other account. Follow the below steps to accomplish the same. 1. Create Credenti...

Read More

marcoadf

SSRS: Information about reports ran

4/6/2010 by marcoadf  -  Comments: 4  -  Views: [11309]

Some times is very useful to gather information about report execution, for example: How often a report is requested Report duration time (slowest reports) User that ran more reports What formats are used the most This information can be achieved from ExecutionLog table, from reportserver database. Running this query: select c.Name as [Report Name], e.InstanceName, e.UserName, e.Status, e.Format, e.Parameters, e.Timestart, e.TimeEnd, datediff(mi,e.Timestart,e.TimeEnd) ExecutionTime, e.TimeDataRe...

Read More

kylewalker

Sample Interview Questions for SSIS jobs

4/6/2010 by kylewalker  -  Comments: 1  -  Views: [10749]

I don't know about you, but for some reason, one of the most terrifying experiences for me is interviewing for a new job. There are a few things that you can do to prepare yourself for an upcoming interview and make it slightly less terrifying. You can work on improving your communication skills and managing whatever nervous habits you may have developed over the years. Or spend some time thinking of some questions that you would like to ask your hopefully-soon-to-be employer, so that when they ...

Read More

timmurphy

Hidden Cells in Excel Export from SSRS

4/6/2010 by timmurphy  -  Comments: 1  -  Views: [7953]

My client wants a report to be exported to Excel. The spreadsheet shows up with what seems to be miscellaneous empty cells when it is exported from SSRS. As it turns out the explanation is pretty simple but I’m not sure there is an easy fix. It has to do with two issues. First, Excel will interpret each object (textbox, image, etc.) and try to match it to a column in the tablix. If the object doesn’t exactly line up with the intended column Excel will create another column. Second, if you merge ...

Read More

BrianKnight

SQL Server 2008 R2 Managament Studio Object Explorer Missing

4/5/2010 by BrianKnight  -  Comments: 5  -  Views: [13077]

I've been using SQL Server 2008 R2 in beta for about 6 months with no issues but today, I had a strange one I'd have to share. In Management Studio, I was adjusting my open windows and at some point Object Explorer closed and would not come back. I was able to get in back in Full Screen only. It turns out that in my registry a key had become corrupt. The easy way to fix it though was to go to Window ---> Reset Window Layout in Managment Studio. After that, I was golden. Well, at least after a...

Read More

SMcDonald

Loss mouse function after virtual pc connection

4/2/2010 by SMcDonald  -  Comments: 1  -  Views: [2158]

I recently experienced a problem with my mouse when I remoted into a virtual pc. Once logged in, I no longer could use the mouse to navigate my way through the screens. I am sure that a lot of us have struggled with figuring out what the hot keys are until we research it. Which is what I had to do and here is what I found at http://brandonlive.com/2009/01/10/windows-7-beta-hotkey-cheat-sheet/ : General Win+Up Maximize Win+Down Restore / Minimize Win+Left Snap to left Win+Right Snap to right Win+...

Read More