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, Yes that's what I figured as well after a while. Thing is, I don't understand how an IDE can be restricted to a certain version of the API... If the assemblies are properly put together you should be able to make calls for a 3.5 assembly from your 2.0 environment with a reference to the...

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 MDXer, Unfortunately I've already come across this article but have not found it very useful for my issue. I already know pretty well the different transaction modes (COM+ programming relies on the MsDTC just like SSIS for transaction handling). As for running the msdtc on the same machine...

Just to mention... I've tried a lot of different things, from having no code in my original SP to using a data flow task instead etc. but nothing would do :(

Me neither, and the strangest of all is that I program COM+ dlls on a daily basis and I've been using my local DTC without any issues since I'm using my local SQL Server. Remote clients require using the remote server's DTC but for development purposes, it's convenient to have everything...

Hi mrdenny, Well that was kinda my next step. But I don't want to have to do that neither mind you. I program COM+ components on a daily basis using ADO connections and transactions and have never had this issue. I tried to change my connection from ADO.NET to ADO and it is actually working...

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...

I see... I think I was not having this reflexion regarding the point of view that looks at the data, which is what determines this requirement... It's like 2 facts could be using totally different time zone settings because they serve different purposes, one for the local stores, one for the...

Hi RiverGuy, Indeed, while it is not a requirement for now, I do need to plan for it because in the future, I could have two offices in different timezones feeding my warehouse. The thing is that you would not look at the data for two different timezones simultaneously, you would want to see...

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...

Definitely. I have been playing a bit with these kinds of parameters recently and I've noticed that simply telling SSIS something can make a big difference compared to thinking it can magically discover or figure it out on its own. I actually appreciate this level of control it gives.

Thanks a lot for the hint, I'll look into perfmon counters in more detail. I would agree with you though, after a closed a few apps I had running and restarted my package, the process took a bit less time and the flows really seemed to execute in parallel. Regards, Greg

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...

MDXer, thanks for the headsup. The more I read about SSIS, the more it influences what I'm designing. I guess that's part of the learning process ;). I've looked at those differen types of transforms and I can definitely say that it will influence my decisions in the future. It's easy to get...

Hi MDXer, I just found the Word document that details the process you mentioned, sorry I don't know why but this is not included in the big zip file that contains the actual data and I'm not sure the actual SSIS packages I got from it contain that process. I think I get what you were saying...

Hi MDXer, I did not know about the project real I just downloaded the 270Mb something setup file but I can't find any other packages than the ones to handle AMO and partitions. Would be kind enough to point to the location of the process you are referring to please? #1 and #3 are not an issue...