| Thread | Last Post | Replies |
|
| Reducing Tables Associations by Using Web Services | 23 Nov 2006 09:37 GMT | 1 |
Hi folks, First,let me use a busniness and solution model - car insurance to present the issue * There are 3 web services - policy, claim, pay. Each services access
|
| SQL Server - Informatica - Sudden ETL slow down | 21 Nov 2006 14:56 GMT | 2 |
We have been facing a problem for almost two months. All of a sudden, we got a 300% performance degradation in our ETL for some tables. Here's the setup on the production server: - We have a server running Microsoft SQL 2000 SP4 with SAN disks, 4
|
| RenDER Reports | 17 Nov 2006 22:22 GMT | 1 |
Can multiple parameterised reports be combined(or rendered) into one PDF or MHTML format? How is it done? Note: The reports generated have same structure but the values in the fields as the input parameter changes.
|
| Good websites for Custom Components | 17 Nov 2006 07:20 GMT | 8 |
I am pretty new to SSIS, so I really appreciate the help! I have been building a few packages for the ETL in a mini data warehouse and I have come across a few tasks that are very common. These include things that, ensuring the business/natural key(s) are unique, or ensuring
|
| Analysis services connection | 14 Nov 2006 10:14 GMT | 3 |
Hi!! 1. I am working with Analysis services 2005 and I would want to know if, Is it recommendable to separate the DB server from of server AS?, Since when I consult the cubes diminishes the performance the server of
|
| error deploying analysis server cube | 14 Nov 2006 10:14 GMT | 1 |
Has anyone ever received this message before? "The Description element at line 3123, column 29 (namespace http://schemas.microsoft.com/analysisservices/2003/engine) cannot appear under
|
| How to improve the performance of server | 13 Nov 2006 15:42 GMT | 1 |
How I can improve particions on Analysis services? Somebody can recommend me a link on this...? Thanks, Cecilia
|
| dwh problem | 11 Nov 2006 09:47 GMT | 2 |
I have to choose between a) using one single fact table b) using one fact table and several dimension tables I know that if you have no dimension tables (i.e. you store all the
|
| Convert integer to date | 10 Nov 2006 16:15 GMT | 1 |
I have a couple of csv files with a date column like '20061231' or '20050521'. What is the easiest way to convert this column into a date in the SSIS pipeline? The connection manager doesn't accept just defining the column as a date.
|
| Connection to Analysis Services 2005 using .NET 2.0 | 09 Nov 2006 02:39 GMT | 1 |
I'm trying to use ASP.NET 2.0 to connect to a 2005 Analysis services database. My script run on a IIS 6 web site under MS Server 2003 SP1. For my test, the Analysis services database and the web site are on the same server. My web site is configured as "Allowed anymous access" with ...
|
| Capture delta or SQL DML | 02 Nov 2006 14:23 GMT | 7 |
Is it possible to capture delta for a specific table or capture DML statement executed against a specific table? thanks
|