Viewing 15 posts - 856 through 870 (of 3,232 total)
I'm not sure I quite follow you. Can you give us a detailed description of what your package is supposed to do and what you are seeing that is...
December 1, 2009 at 12:15 pm
How are you executing the SQL scripts against the DB?
December 1, 2009 at 11:39 am
The first link on the page should do.....
November 30, 2009 at 5:01 pm
If you can't do what Jack is suggesting, you can surely use the Data Conversion transformation to get your data in the correct type for comparison. You should not...
November 30, 2009 at 4:01 pm
I can personally say that SSC has had a huge impact on my professional development. I honestly would not be where I am today without it.
Thanks Steve,...
November 30, 2009 at 10:44 am
Did you look into using Snapshot isolation? There is no client side cache, the database handles all of the comparisons and notifies the application when the data has changed....
November 30, 2009 at 9:33 am
Role membership can be granted to Windows users. I don't think there is a way to tie your roles back to application level data (user table).
November 24, 2009 at 12:07 pm
This is an NTFS issue with your folder permissions. Look at the folder where you're files live and check out the permission settings at the folder level and for...
November 24, 2009 at 12:06 pm
You may have to add another calculated column that holds the values for the non-zero rows. Use NULL for the zero rows so that you can use the COUNT...
November 24, 2009 at 10:58 am
I would suggest performing some diagnostic steps to determine why the system is performing slowly so you know where to focus your efforts.
If this were me, I'd set...
November 23, 2009 at 10:13 am
OK, so you got the 100 amount to appear in the Billed column. Good start. If you are seeing that summed in your cube, that's because you've also...
November 23, 2009 at 9:50 am
Using TYPE should not affect whether the results are NULL or not; TYPE affects XML formatting.
As far as this not working on a different server, check the SQL...
November 19, 2009 at 3:56 pm
You could change you DSV to use a named query instead of your table. This would allow you to write the SQL to create the 'Billed' column value at...
November 19, 2009 at 3:11 pm
Well, what does your data look like? Can you post the DDL for the the relevent tables?
November 19, 2009 at 2:21 pm
Viewing 15 posts - 856 through 870 (of 3,232 total)