Search results for query: *

Hello, I just discovered, while trying to figure out how to cluster SSIS, that the service itself is not cluster aware. However, with proper transaction levels etc. I can get my packages to fail graciously during a node switch. But at the same time, I just discovered, while reading up on it...

Hi, I have an interesting problem with a simple SSIS package that I cannot debug easily, I was wondering if I could get pointers as to how I can eiher debug it better or solve my problem. I have a simple package that reads a table and puts the data into a staging area. Then, there is a...

Hi there, I am desining a simle ETL package that has a main sequence container for which I set the Transaction Attribute to "Required". In this container, I have a data flow task followed by an EXECUTE SQL task and based on the results of that query, a simple ForEach Loop container (ie inside...

Hi there, I'm not sure this is the right place for this but I haven't found a forum that seems to be better suited for this. If there is, please let me know and sorry for the noise. I'm trying to design a simple Script Task in a Data Flow for which I need classes that are in the...

Hello, I was just reading up about date dimensions and handling various timezones when using them when I stumbled upon the following thread: thread353-1421422 I read it over and over and my only conclusion is that handling time zones is not easy... btw, thanks for all the comments in that...

Hello, I am still and again implementing my small sample data warehouse and I am now facing an interesting challenge, that of an accumulating snapshot. However, there is a trick to id... Say I have data in my staging table such as: ID ItemId Action TimeStamp 1 1 1...

Hi, I have a question that is going to seem really stupid but I feel I have to ask anyways... Say I have a master dimension package that calls a number of children dimension packages. These packages pool data from my staging tables and do the ETL process to their dedicated final dimension...

Hi, For those who've read my previous post, I'm still trying to design my little sample data warehouse :). I'm trying to have, in my fact table, an attribute that links to the previous fact row. My fact is: ID ProductID TimeStamp PreviousStamp (that's the one I'm trying to fill). In other...

Hello, I'm designing my first SSIS packages for a small data warehouse I'm trying out as a first sample project. I've already designed my dimension packages, which are not so much of an issue. Where I'm having trouble is in my fact table package. My fact table contains a number of FKs pointing...

Hello, I was wondering how people usually deal with dimension attributes that are really other dimensions. For instance, a product with a product group. I need my product group to be "translatable" to other languages so I wanted to treat it as a separate type 1 dimension. But then this means...

Hello, I'm in the process of modeling a fact table that tracks the history of a certain product (arguably not really a fact table but that's another question altogether...). My problem is that there is a need to show an 'old value' and a 'new value' for changes in this product's attributes. I'm...

Hello, I'm in the process of building a sample data warehouse and I would like to get some feedback regarding the package layout people generally use. I was thinking of having a master package that calls 1 package for all dimensions and 1 package for each of my fact table. I was wondering what...

Hello, I'm beginning using SSIS and I've got myself the wrox book (I use 2005 but I could only find the 2008 version of the book) recently so I am going over it for help but I have a question. I have a table in a source operational DB. I want to load the information from that table into my DW...

Hello, I am in the process of trying to design a simple fact table with a couple of dimensions, including a date dimension. I am wondering however how people deal with dates in terms of time zones etc. I was thinking of handling by having two date FKs in my fact table: one for the local time...

Hello, I have some fairly good knowledge of SQL Server 2000/2005. However, I am yet to play with SSIS which I want to use to try out some ETL/DW things for work. I was wondering if anybody could point me out to a good, practical book for ETL that's SSIS-centric? I've been searching at amazon...

Hi, I was wondering something but I can't find it in Kimball's books... If I have two facts that make use of the same dimension 'product', would I have one dimension 'product' or one dimension per fact table so that I can maintain them separately? I can see how this can be a pain in ETL to have...

Hello, This is my first post here so hi everyone :) I have a question regarding dimensional modeling. I've got myself two of Kimball's books (The DW Toolkit and the SQL 2005 version of it) and I'm trying to analyze some requirements I have to come up with a simple proof-of-concept dimensional...