Viewing 15 posts - 1 through 15 (of 64 total)
This problem becomes pretty easy if you can add a "RowID" to each member of a group with the same MembID. Then you can LEFT JOIN the table to...
February 9, 2011 at 11:43 am
CDONTS and SQLMail are deprecated. DatabaseMail is the way to go. It's much easier because you just need a SMTP server to bounce your mail through instead of having...
February 9, 2011 at 11:14 am
The error suggests that the defined size of "Column 2" is not big enough to hold the data you are trying to load. You need to either edit the Flat...
January 19, 2011 at 1:12 pm
No problem! It's a different way of thinking and takes some getting used to.
If you need to be able to drill-down along a pre-determined path (e.g. Call to Connect...
January 10, 2011 at 12:48 pm
You're definitely on the right track now.
Facts are generally transactional records from your source systems. They contain the measures (numbers) that you want to summarize combined with...
January 10, 2011 at 10:39 am
What I don't see in your example is a dimension table called DimCall. If you want to roll up by CallTableID, you will need a dimension that allows you...
January 7, 2011 at 2:07 pm
Is CallTableID the key of dimension you want to roll your measures up to and you want to build a hierarchy to drill down on Connect, Queue and Activity? ...
January 7, 2011 at 12:35 pm
If you can afford to have the source systems down for a short time, the quick and dirty way is to detach all of the databases on the source server,...
January 6, 2011 at 11:59 am
If you have it available, try browsing the same data in Excel 2007 and see if the problem persists. I have run in to a similar issue browsing time...
March 3, 2010 at 8:40 am
Also make sure that the CALCULATE; statement is the first line of cube calculation script (Calculations tab). If this statement is missing, the cube will show no data.
February 22, 2010 at 6:33 am
The error indicates that it is the package execution log file that has the problem. Open your package in BIDS then click SSIS...Logging on the menu. When the...
September 24, 2009 at 7:51 am
The thing that noone has mentioned is that varchar requires an extra two bytes to store the length of the field. So a varchar(1) column will still occupy three...
June 5, 2009 at 7:05 am
If you have a key value on your .csv file, you could use a lookup task in your package before your OLEDB destination component. The lookup task would check...
March 5, 2009 at 7:29 am
If I understand you correctly, you want the table name in a query to be dynamic based on the environment your package is installed in. Is that correct?
I would...
March 3, 2009 at 7:13 am
Is there a reason you can't use SSIS configurations in the pacakge? If you save the connection string information in a configuration XML file, you can deploy the file...
February 26, 2009 at 7:33 am
Viewing 15 posts - 1 through 15 (of 64 total)