Package Validation Error

Hi,

I am using Look-UP Transformation to do ETL from a Flat file to a SQL Server Fact Table doing Keylookups from different Dimension Tables:

I am using two connections in the Connection manager, One for the FlatFile and one for the SQLServer Table..

While Executing the Package, I am getting the following error:

TITLE: Package Validation Error

Package Validation Error

ADDITIONAL INFORMATION:

Error at Data Flow Task [DTS.Pipeline]: The "runtime connection "OleDbConnection" (110)" in the connection manager collection, Connections, of "component "OLE DB Destination" (102)" does not have a value for the ID property. Verify that the ConnectionManagerID property of the runtime connection object has been set for the component.

Error at Data Flow Task [DTS.Pipeline]: component "OLE DB Destination" (102) failed validation and returned error code 0xC004801C.

Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

BUTTONS:

OK

Can anyone help me ?

Thanks in Advance,

Sundar

I guess this might help you:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=108043&SiteID=1

|||Make sure that in the flat file source and the destination that you have actually chosen a connection manager.

You'll get this error if you don't chose a connection manager.|||

Thanks a lot Phil and Unni.

Once I configured the connection Manager, Package worked like a charm !!

Cheers,

Sundar

OWC - Distinct Count Error

hi,

i have a cube where i do a "distinct count" of my customers and it works fine if i select one member off a dimension or all of them. but if i try to choose two or more members it doesn't work anymore.

does anyone have a solution for this problem ?

thanks,

levogiro.

Are you using AS 2005 SP2 - in which case, could you describe the issue in more detail?

http://sqljunkies.com/WebLog/mosha/archive/2006/11/07/visual_totals_dc.aspx

>>

Visual Totals and Distinct Count

One of the most talked about improvements in Analysis Services 2005 was support for Distinct Count measure over arbitrary set of members.

...

Wrong results are always a bad thing, therefore in SP2 the implementation of Visual Totals (both function and the mode) underwent serious change. Internally, this implementation got unified with implementation of visual totals for subselects - so now they all behave similarly.

>>

|||

Deepak Puri,

I'm sorry, I forgot to say that I'm using SQL Server 2000. I did a test in SQL Server 2005 and it works fine.

Levogiro.

|||I believe there was a hotfix for this issue (in AS 2000) recently. Please follow up with CSS...|||I have the same problem. Does anyone know if there actually is there a hotfix for AS2000 for this?

OWC - Distinct Count Error

hi,

i have a cube where i do a "distinct count" of my customers and it works fine if i select one member off a dimension or all of them. but if i try to choose two or more members it doesn't work anymore.

does anyone have a solution for this problem ?

thanks,

levogiro.

Are you using AS 2005 SP2 - in which case, could you describe the issue in more detail?

http://sqljunkies.com/WebLog/mosha/archive/2006/11/07/visual_totals_dc.aspx

>>

Visual Totals and Distinct Count

One of the most talked about improvements in Analysis Services 2005 was support for Distinct Count measure over arbitrary set of members.

...

Wrong results are always a bad thing, therefore in SP2 the implementation of Visual Totals (both function and the mode) underwent serious change. Internally, this implementation got unified with implementation of visual totals for subselects - so now they all behave similarly.

>>

|||

Deepak Puri,

I'm sorry, I forgot to say that I'm using SQL Server 2000. I did a test in SQL Server 2005 and it works fine.

Levogiro.

|||I believe there was a hotfix for this issue (in AS 2000) recently. Please follow up with CSS...|||I have the same problem. Does anyone know if there actually is there a hotfix for AS2000 for this?

Overriding repeating totals from non-referenced slicer dimension

I've run across what appears to be a change in the default behavior of Analysis Services from 2000 to 2005. My question is how to get the default behavior to revert to the AS 2000 method.

If you have a cube with multiple measure groups or multiple linked cubes, queries that try to slice a measure using a dimension that is not related to the measure result in the total amount for any other slicers being repeated across the "invalid" slicer.

For example, the following query slices the reseller amount by calendar year and employee department. The results are as expected. Only the Sales department has any totals for the measure and all other departments return null.

SELECT { [Employee].[Employee Department].[All Employees].CHILDREN } ON COLUMNS ,{ DESCENDANTS( [Date].[Calendar].[All Periods], [Date].[Calendar].[Calendar Year] ) } ON ROWS FROM [Adventure Works] WHERE ( [Measures].[Reseller Sales Amount] );

The next query is identical, except it using the Internet Sales Amount measure, which comes from a measure group that does not have a link to the Employee dimension. The result is the total amount for internet sales is displayed across all employee departments. In AS 2000, the results would have been null or empty.

SELECT { [Employee].[Employee Department].[All Employees].CHILDREN } ON COLUMNS ,{ DESCENDANTS( [Date].[Calendar].[All Periods], [Date].[Calendar].[Calendar Year] ) } ON ROWS FROM [Adventure Works] WHERE ( [Measures].[Internet Sales Amount] );

At one level I can agree with the change, but non-the-less, it is a change in the default behavior, and users hate it. Is ther any way to revert this behavior back to the AS 2000 approach?

Thanks!

What you are running into is the fact that AS2K5 now applies ValidMeasure() automatically. You can revert back to AS2K behavior by setting the "IgnoreUnrelatedDimensions" property associated with your measure group to "False".

HTH,

- Steve

|||

Steve,

Many thanks! I knew it would be something simple, but was getting tired of looking...

overflow of the data type while processing dimension

While trying to process a cube the error below came up while processing one of the dimensions.

The database is an ORACLE database running on a UNIX platform even though that piece of information would not be neccesary in solving this riddle.

I believe it has to do with date format differences on both database platforms. Is there anyone out there who has been able to resolve such a problem or point me out in the right direction.

See below for an excerpt of the log.

Start time: 30-Mar-07 13:04:47; End time: 30-Mar-07 13:05:02; Duration: 0:00:15
SQL queries 1
SELECT
DISTINCT
"T_0"."DEALER_CODE" "DIMM_SUBSCRIBER_DEALER_XREF0_0"
FROM "DLRPROFILE"."DIMM_SUBSCRIBER_DEALER_XREF" "T_0"
Processing Dimension Attribute 'ENTRY DATE' failed. 1 rows have been read.
Start time: 30-Mar-07 13:04:47; End time: 30-Mar-07 13:06:06; Duration: 0:01:19
SQL queries 1
SELECT
DISTINCT
"T_0"."ENTRY_DATE" "DIMM_SUBSCRIBER_DEALER_XREF0_0"
FROM "DLRPROFILE"."DIMM_SUBSCRIBER_DEALER_XREF" "T_0"
Error Messages 1
Errors in the back-end database access module. OLE DB reported an overflow of the data type for column 0. Errors in the OLAP storage engine: An error occurred while the 'ENTRY DATE' attribute of the 'DIMM SUBSCRIBER DEALER XREF' dimension from the 'DEALER_SALES_CONNECTION_ANALYSIS' database was being processed.
Processing Dimension Attribute 'REGION CODE' completed successfully. 10 rows have been read.
Start time: 30-Mar-07 13:04:47; End time: 30-Mar-07 13:06:06; Duration: 0:01:19

Please another question is there some sort of literature addressing SSAS and ORACLE database working in tandem.

I need Help.......

What is the data type of the column for the 'ENTRY DATE' attribute in Oracle compared with the data type that is setup for the Attribute in the dimension? It sounds like the attribute is using a smaller data type.