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

How are you executing the SQL scripts against the DB?

The first link on the page should do.....

http://www.lmgtfy.com/?q=The+local+computer+may+not+have+the+necessary+registry+information+or+message+DLL+files+to+display+messages+from+a+remote+computer

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

Bahamas

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

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

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

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

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

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

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

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

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

Well, what does your data look like? Can you post the DDL for the the relevent tables?