SqlServerKudos

Warehousing

2
kudos

Kudos

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

published 37 days, 7 hours, 24 minutes ago posted by

jacobsebastian 46 days, 7 hours, 2 minutes ago

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

In this post, Jason provides a quick overview of SSAS Dimension Attribute properties and provides a wonderful explanation of each property. (more)

category: Warehousing | clicked: 0 | comment | | source: beyondrelational.com

tags: analysis, Cube, Data Mining, Data Warehousing, database, Dimension, SQLServer, SSAS

2
kudos

Kudos

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

published 55 days, 8 hours, 46 minutes ago posted by

jacobsebastian 64 days, 12 hours, 15 minutes ago

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

Many times, it can happen that we end up writing very complex MDX expressions revolving sets. To simplify such expressions or to improve the performance of some queries, we can extract the definitions of some sets into a separate named set expression which are called named sets. A named set can be created either using a CREATE SET statement or a WITH SET statement (For syntax, refer Building Named Sets in MDX). In SQL Server 2005, there was only the Static named sets feature but in SQL Server 2008, both ... (more)

category: Warehousing | clicked: 1 | comment | | source: beyondrelational.com

tags: MDX, SSAS

1
kudos

Kudos

SSIS Package Reuse - Dave Ballantyne's Blog

published 66 days, 9 hours, 36 minutes ago posted by

jacobsebastian 72 days, 13 hours, 36 minutes ago

SSIS Package Reuse - Dave Ballantyne's Blog

To me, as a professional software developer, SSIS is severely hindered by its lack of the ability to pass variables into a package. It is such an obvious and simple piece of functionality that it seems incredible to believe that, within SSIS as standard, a parent process cannot tell a child how to behave. This is almost akin to not being able to pass parameters into a function. After trying various methods (calling DTSRun , storing the variables in a table, etc.), none of which I was entirely happy with,... (more)

category: Warehousing | clicked: 1 | comment | | source: beyondrelational.com

2
kudos

Kudos

Loading data from text files to SQL Server Tables – CSV Files, Tab Separated Files or Fixed Column Length Files - Ashish's Blog On SQL Server

published 75 days, 10 hours, 15 minutes ago posted by

ashishgilhotra 85 days, 7 hours, 1 minute ago

Loading data from text files to SQL Server Tables – CSV Files, Tab Separated Files or Fixed Column Length Files - Ashish's Blog On SQL Server

In the previous post we looked in How to Execute SQL Query or Store Procedure from SSIS and successfully created a package which execute SQL Query or Procedure on targeted SQL Server with the help of this. In this post we look in How to Load Data from text Files to SQL Server, in daily life several time we need to load data in SQL Server tables, we can achieve this with the help of SSIS. We look into the detailed process of loading data from text files to SQL Server tables. (more)

category: Warehousing | clicked: 1 | comment | | source: beyondrelational.com

1
kudos

Kudos

Working with SSIS Expressions

published 282 days, 4 hours, 28 minutes ago posted by

sa 291 days, 23 hours, 59 minutes ago

In SQL Server Integration Services (SSIS) Packages, expressions are everywhere. You may have worked with Expressions in some of the transformation tasks, such as the Derive Column Transformation, but did you know they can also be used to set the properties of many of the tasks and transformations, or even used to modify the values in your SSIS Variables? Let’s look at an example. What if you have to write a lookup query that pulls data from two databases on the same SQL Server but you’re not sure what th... (more)

category: Warehousing | clicked: 2 | comment | | source: sqlblog.com

tags: SSIS

1
kudos

Kudos

Trick Question – Part I

published 326 days, 7 hours, 37 minutes ago posted by

sa 332 days, 3 hours, 36 minutes ago

It seems simple enough, yet there's so little consensus about how to do this basic thing that we grapple with every day. In my work, I have to poke and prod a wide variety of third-party applications, and I can say that there's fairly little consistency -- and, frankly, a pretty low level of quality -- around this issue, if you go shopping to buy software. Everyone is basically doing the same "thing": creating an ob... (more)

category: Warehousing | clicked: 0 | comment | | source: sqlblog.com

tags: BI

1
kudos

Kudos

SSIS – Unpack a ZIP file with the Script Task

published 331 days, 2 hours, 37 minutes ago posted by

sa 337 days, 23 hours, 34 minutes ago

SSIS – Unpack a ZIP file with the Script Task

A while ago I needed to unpack a couple of zip files from SSIS. There is no Microsoft SSIS task that contains this functionality so I searched the Internet. It seems that there are quite some third party tools that offer this functionally. It's also possible to download custom SSIS tasks. I personally always try to avoid third party tools and custom tasks so I searched on. It seemed there is a way to unzip files from SSIS with the Script Task. With some Visual Basic code using the Visual J# Library you ... (more)

category: Warehousing | clicked: 6 | comment | | source: sqlblogcasts.com

tags: Expressions, Script Task, SQL Server 2008, SQL Server Integration Services, SSIS, Unpack zip file, Unzip, VB .NET, vjslib.dll

1
kudos

Kudos

Project Gemini – Videos available

published 332 days, 6 hours, 41 minutes ago posted by

sa 338 days, 22 hours, 9 minutes ago

I previously posted about using Project Gemini as a tool for scientific analysis – as a quick way to learn about them and see them in action, take a look at the one minute Gemini videos by Donald Farmer. One of the latest videos is about using Reports as data sources and highlights the orange button for getting data sets. This is a perfect way for scientists to publish data and easily make the feeds available for others to consume. It could even be included in papers to easily enable research reproduc... (more)

category: Warehousing | clicked: 1 | comment | | source: blogs.msdn.com

tags: Data Analysis, eScience, Gemini

1
kudos

Kudos

Gemini Cures Cancer…Not!

published 332 days, 6 hours, 41 minutes ago posted by

sa 338 days, 23 hours, 1 minute ago

Most of the people reading this blog have probably also seen demos or at least heard of Gemini and it’s magical powers of solving all BI problems known and unknown. (And you probably want to be looking at it. You can see if you get accepted to the CTP from the instructions here. I understand that you’ll automatically get the preview of Office 2010 if you’re accepted…) From my perspective of implementing the PerformancePoint Planning Excel AddIn, I can say Gemini would have been a huge help. The compress... (more)

category: Warehousing | clicked: 1 | comment | | source: blogs.msdn.com

tags: Business Rules, Excel, Gemini, MDX, PPS

1
kudos

Kudos

Getting Started with Variables in SSIS

published 334 days, 19 hours, 46 minutes ago posted by

sa 339 days, 22 hours, 4 minutes ago

I recently had to create an SSIS package that used variables to pass data between procs, and I thought it would make a good topic for a blog post. There are many scenarios as to the how and why to use variables in SSIS, but we’re going to keep it pretty simple. Let’s assume we have some need to retrieve data from Proc A, pass it to Proc B, and store the results in Table C. First, let’s set up our environment:US... (more)

category: Warehousing | clicked: 1 | comment | | source: sqlfool.com

tags: BI, BIDS, SSIS, Variables

1
kudos

Kudos

Addressing the MSFT BI Naysayers

published 341 days, 4 hours, 18 minutes ago posted by

sa 347 days, 1 hour, 13 minutes ago

Overall, could MSFT BI be a better story (see ProClarity)? YES. Does MSFT need a better, unified platform vision for it's BI story? YES. All that being said, the MSFT BI software products are good platforms for building an enterprise BI solution on top ... (more)

category: Warehousing | clicked: 2 | comment | | source: weblogs.sqlteam.com

tags: BI

1
kudos

Kudos

Where is the intelligence in Business Intelligence?

published 348 days, 6 hours, 40 minutes ago posted by

sa 354 days, 22 hours, 43 minutes ago

Where is the intelligence in Business Intelligence?

Many people believe that if they go ahead and implement a Business Intelligence solution they will suddenly have an intelligent business that will tell them how it is operating and what they need to do. Customers they need contacting will be flagged, orders that are likely to be late are notified so as to keep the customers happy, and the boss is alerted as to the reason profits have fallen from 15% to 10%. (more)

category: Warehousing | clicked: 3 | comment | | source: sqlblogcasts.com

tags: BI, SQL Server 2008, SQL Server 2008 R2, SQLBits, Training

1
kudos

Kudos

Hexagonal Close Packing for your Fact Data

published 351 days, 5 hours, 31 minutes ago posted by

sa 355 days, 1 hour, 40 minutes ago

Hexagonal Close Packing for your Fact Data

Disclaimer: It's likely you don't really want to do what I am proposing in this post. This is just an esoteric defrag process, which won't really deliver much performance benefit but carries a fair amount of risk. I present it purely as a curiosity. To paraphrase Scott Hanselman, you might just want to run away at this point, as I can only guarantee that this is an idea, not a good idea. Modest fragmentation has a minor effect on most systems, and what follows is definitely overkill. And it might not eve... (more)

category: Warehousing | clicked: 0 | comment | | source: sqlblog.com

tags: Defragmentation, PowerShell

1
kudos

Kudos

Editing Configuration files : SSIS Nugget

published 355 days, 5 hours, 32 minutes ago posted by

sa 359 days, 22 hours, 41 minutes ago

Editing Configuration files : SSIS Nugget

Its been a long-g-g-g-g time since I did a SSIS-related post so here’s a little ditty that I picked up while reviewing some internal stuff today. Editing SSIS configuration (i.e. .dtsConfig) files isn’t particularly easy. Most people I see who try to do this use a traditional text editor like Notepad but that isn’t a great experience because the contents don’t look particularly friendly when you open them up. Observe: Instead you may wish to use Visual Studio which, if you’re messing about with SSIS ... (more)

category: Warehousing | clicked: 2 | comment | | source: blogs.conchango.com

tags: configurations, Nugget, SQL Server, SQL Server Integration Services, SSIS

1
kudos

Kudos

SQL With A Plan : Large Scale DW/BI Design Considerations

published 364 days, 3 hours, 35 minutes ago posted by

sa 367 days, 4 hours, 44 minutes ago

SQL With A Plan : Large Scale DW/BI Design Considerations

One of the most challenging aspects of large scale data warehouse development is the sheer immense size. It’s common to see all sorts of problems once the data warehouse gets larger. Common problems include performance degradation, out of storage space, long running queries, blocking and failure to keep up with data feeds. I have compiled a list of tips that help me to manage the size effectively over the years on terabyte DW projects. I hope they will be beneficial to you as well. Here we go: ... (more)

category: Warehousing | clicked: 0 | comment | | source: blogs.msdn.com

tags: Batch, Fault Tolerance, Performance, Scalability

1
kudos

Kudos

SSIS Accelerator Series: Working with SSIS Expressions

published 369 days, 7 hours, 52 minutes ago posted by

sa 370 days, 14 hours, 1 minute ago

SSIS Accelerator Series: Working with SSIS Expressions

Whether you’ve been involved with SQL Server Integration Services (SSIS) for years or are just learning SSIS, you’ve probably found the learning curve of the SSIS expression language quite challenging. The expression language is a core component of SSIS that helps users make any component in an SSIS packages dynamic and also helps the data flow make workflow decisions. This whitepaper walks you through a crash course in the SSIS expression language across all components of SSIS. After you complete this w... (more)

category: Warehousing | clicked: 8 | comment | | source: blogs.pragmaticworks.com

tags: Expression Language, SSIS

Welcome!

Warehousing

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

SSIS Package Reuse - Dave Ballantyne's Blog

Loading data from text files to SQL Server Tables – CSV Files, Tab Separated Files or Fixed Column Length Files - Ashish's Blog On SQL Server

Working with SSIS Expressions

Trick Question – Part I

SSIS – Unpack a ZIP file with the Script Task

Project Gemini – Videos available

Gemini Cures Cancer…Not!

Getting Started with Variables in SSIS

Addressing the MSFT BI Naysayers

Where is the intelligence in Business Intelligence?

Hexagonal Close Packing for your Fact Data

Editing Configuration files : SSIS Nugget

SQL With A Plan : Large Scale DW/BI Design Considerations

SSIS Accelerator Series: Working with SSIS Expressions

Open ID Login

Standard Login

Forgot Password?

Sign up