BI Developer Network Community

 You have chars left.

• SSIS Renaming and Moving Tasks
  If you are like me you click the mouse a lot, and fast. I drive my mouse to the breaking point clicking around so fast on items, especially in SSIS, which is a graphical interface. But when clicking on the tasks in SSIS I sometimes end up in the rename fu...
  3/4/2010 4:11:19 PM - Comments:4
• SSIS Excute SQL Task Fails with Executing the Query " " Failed
  When running a package with an execute SQL Task it is easy to get syntax errors. If the tasks turns red, but still accomplished its work, like an insert statement and the error you recieve is: Executing the Query " " Failed ...  This is saying the query w...
  3/2/2010 5:57:21 PM - Comments:0
• SSRS 2008 Report Model with no Foreign Key and/or primary Key
  When creating report models you might run into bad database designs where the tables have no foreign keys and/or no primary keys. This can be resolved in the report model DSV. I have created two tables, One with first names, the second with last names. Ea...
  2/26/2010 9:57:11 AM - Comments:0
• SSRS 2008 Change the Series Colors for Chart and Legend
  In my last SSRS 2008 class I was showing the students the chart tools and used color as a series on a chart. It was the product color column from the AdventureWorks 2008 Production.Product table. The series automatically chooses colors based on the ...
  2/25/2010 12:48:27 PM - Comments:0
• SSRS Expressions MTD Month to Date
  If you have a report in SQL server reporting services that has start and end date parameters, you may want to have default dates to show the current month to date. The end date is easy, it is just the today() function. The start date needs to get the firs...
  2/24/2010 1:46:53 PM - Comments:0
• SSIS 2008 Setting proper case with a Script Component
  There is a command in VB that can be used to character data to proper case. This is the first letter of each word is capitalized and the rest is lower case. This is a great way to clean up a data base or is great to use when loading a data warehouse. Drag...
  2/17/2010 8:38:21 PM - Comments:0
• Using Stored Procedures in SSIS
  When you are creating an SSIS package with a data flow, it is a Best Practice to use a stored procedure for the queries. This makes it easy to adjust the queries without having to redeploy the packages. Here is stored procedure I am using. It is pulling f...
  2/16/2010 10:31:29 AM - Comments:0
• SSAS 2008 Dimension Source Table Wrong
  I was working in SSAS 2008 the other day and I noticed the source table shows up wrong in my cube when I change the key column for a dimension. This does not break the dimension nor the cube, it is simply a strange bug. It does not happen all the time and...
  2/11/2010 11:46:12 PM - Comments:0
• SSIS expression First day of next year
  If you just want January 1 of the next year here is the easiest way to do it. If you want a different year just change the "+1" to a different number. For example: if you want 2 years ago change it to "-2". This number could also be a variable to make the...
  2/3/2010 2:15:21 PM - Comments:0
• Iron Chef Data Warehouse Edition SQL Saturday SSAS
  For those of you who did not make it to SQL Saturday in Tampa you missed the best presentation ever. It was an Iron Chef like competition between Brian Knight and Adam Jorgensen . They went head to head in an attempt to build a data warehouse from a unive...
  2/2/2010 3:24:04 PM - Comments:2