Viewing 15 posts - 1 through 15 (of 58 total)
From a modelling perspective from what you have said, I would say your best bet is to create a Junk Dimension or Junk Dimensions depending upon the data in these...
March 24, 2014 at 5:56 am
You need to go back and think about your design. What you are trying to achieve from a Modelling point of view is correct but not the way you are...
September 9, 2013 at 2:04 am
"I am looking to connect the TestDetails dimensions to the test measure".
Then you either need to combine the tables as I indicated so that you have one fact table. All...
February 21, 2013 at 2:16 am
I am not entirely sure what you are trying to do by your description, but essentially if I understand it you have two fact tables.
What are you exactly trying to...
February 20, 2013 at 10:50 am
Not as far as I am aware.
You state the requirement is to run the tasks in parallel, but why ?
If there is a lot of data processing then running them...
June 7, 2012 at 5:10 am
I don't believe you will be able to run the two SQL Tasks simultaneously if they are transacted.
I have received exactly the same error when attempting to run two SC's...
June 7, 2012 at 4:43 am
I would definitely like to see some more videos. Short snippets of 5 mins videos of e.g. how to tasks, would be useful.
The forums could do with sorting out as...
May 19, 2010 at 3:54 am
While Frank is correct in saying that 2008 can accommodate this through the use of the cache transform, I believe it is possible in 2005 through a workaround.
While the lookup...
October 14, 2009 at 8:50 am
That is true.
I'm surprised the SCD behaves in this way when I think about it because unless a DW is a real-time feed, it is quite common for the source...
September 3, 2009 at 10:39 am
The assumptions been made in the replies that the PK of the data source is the PK in the Dimension which normally it wouldn't be. The PK source acts as...
September 3, 2009 at 10:06 am
I have had so many issues with TransactionOption in SSIS that I don't use it anylonger. It is not a feature within SSIS that I trust.
A shot in the dark....
June 24, 2009 at 5:04 am
To further clarify a point, the Merge Join may have to be directly connected to the data source when the data source 'IsSorted' property is set to True. If there...
June 5, 2009 at 2:03 am
A very nice interesting and easy to read article on partitioning.
There are a couple of errors in the syntax though with regards to creating a partition function:
CREATE PARTITION FUNCTION partfunc...
April 29, 2009 at 2:34 am
It's not really of any benefit to write the import routine in an sp., and then run that from within SSIS as you are not taking advantage of any of...
February 4, 2009 at 11:42 am
Yes it is true that there is an issue with size when using many Script components or Script transforms in the package which does affect the size of the package....
December 24, 2008 at 1:53 am
Viewing 15 posts - 1 through 15 (of 58 total)