Sorry. It is 1753, was a typo. and SQL Server 2005.

So I see the only way is either to change the data type of the destination table to varchar

or...

Its desperation. My bad.

This is so stupid. I had the some problem, even without looking up online. I re-installed SQL Server.

Double click worked. Thanks guys

The attinuity connectors for Oracle did the job, got million records in less than a minute.

Thank you.

I am using the OLE db provider for Oracle that comes with SSIS.

I saw a post about using Oracle attinuity tool or something. I am really not sure if...

Q1/Q2 - Does assigning PK/ FK affect my load process, if so can I create PK/FK after the loading process is over?

Q3- Sounds good. How do I implement parallelism?...

I used the NORows Properties to show a custom message. I hope this is what the T lead is looking for.

To make it simple.

When there is a wrong parameter a user types in. I need to show a custom error in SSRS to say "parameter is invalid, enter the...

Just a quick Question. Is this forum still alive or is it that my question is boring?

Yay! I got it working.:cool:

Its stepped layout format. If anyone comes across the same issue. Search online for stepped layout matrix.

And also it should have drill down functionality. Say group1 should drill down into project 1 and project 2.

I can get get project1 and project2 beneath group1 by doing...

Hey I got this issue fixed. Nothing worng with the code. unfortunately I was using the server which had less memory and the SSRS crashed to get this report.

I...

I dont think my company would agree with that. Anywho, How do i move this topic to the analysis service forum?

http://msdn.microsoft.com/en-us/library/aa255841(SQL.80).aspx

Follow the instructions.

SELECT

NON EMPTY {

( Distinct ( [Dim Tempo].[Calendario].[Ano].&[2009]*

[Dim Tempo].[Calendario].[Ano].&[2010]*

[Measures].[Val Pago - Valor Recolhido]*

[Measures].[Val Tributo - Valor Recolhido]))}

DIMENSION PROPERTIES MEMBER_TYPE ON COLUMNS,

NON EMPTY

{CrossJoin (...