The problem is that you are using absolute paths rather than relative paths.SELECT *

FROM OPENXML( @i, '/Return/SOURCE/DEST/MAPPING/MAP',2)

WITH (

Entity VARCHAR(10) '@ENTITY',

MapId VARCHAR(10) '@MAP_ID',

Form VARCHAR(10) '@FORM',

Field VARCHAR(10) '@FIELD',

Page VARCHAR(1000) '@PAGE',

DDMType VARCHAR(10) '@DDM_TYPE',

OverrideMessage...

It might also help to give an overview of what the tables represent and what you are trying to accomplish.

I also notice that you are joining the CASEEVENT table a...

Is your EndDate always the same as the PeriodEndingDate? If not, when is it different and what should the value be?

Drew

A big part of your problem is that your data is not normalized. Having normalized data will greatly reduce the need for CASE statements. I was able to...

I find the EXCEPT clause works well in these situations, particularly as the number of columns you want to compare increases.

SELECT *

FROM db1..tbl1

EXCEPT

SELECT *

FROM db2..tbl1

Drew

When running it manually, you are using your...

SSIS bases its datatypes on a sampling of the records (8 rows by default) from the Excel file. If none of the records in the sample are longer than...

First, the parent package CONTAINS the child package. The success/failure of the parent package is not determined until it finishes executing and it cannot finish executing until each of...

You're going to have to use ParallelPeriod(). If you have the week level in your hierarchy, that will probably work best. ParallelPeriod([week], 52, [FromDate]):ParallelPeriod([week],52,[ToDate]). Something like that...

The "Available Values" for your parameter is set to "From a Query". It is this query that you need to change.

Drew

It depends on whether you're querying a dimension or a hierarchy. With a dimension it's easy, just change [Dimension].members to [Dimension].children. For the hierarchy, it depends on how...

It's really hard to say for sure, because so much depends on the actual structure of your cube.

I think that you're probably going to need to reference the .currentmember of...

You need to use StrToMember() to convert your parameter value to a member.

Drew

I think that this is one of the cases where a CTE is much, much clearer. First, it makes it obvious that you are joining the same query to...

You could also use a CTE.

WITH CTE AS (

SELECT

orderlineid

, date

...