Does your source have to be Excel? Can you save the Excel file to csv?

Might save you time

In my experience it is better to create the index after loading the data for large data loads. However 1 million records in a single columns tables isn't too bad....

It would only take a couple of minutes to try connecting the cube through a new pivot table on a new speadsheet. Have you tried this yet?

I have seen...

Microsoft® SQL Server™ 2005 Analysis Services Step by Step

This book is for beginners if you like the walk through tutorial approach. It is a good way of getting an overview...

David's SQL is pretty neat for your original request. I think you would do well to beat this using vb to find and retrieve the records.

Regards

Daniel

Hi,

I assume you meant the first 2 characters by your result set.

You could do it via a Union. The second query has to take into consideration what the first returns.

Something...

Check this out.

http://www.sqldts.com/default.aspx?6,103,246,0,1

Regards

Daniel

Hi,

Here are 2 things to try.

1. Add the following setting to you SP

SET FMTONLY OFF

2. Don't use the wizard! To create a new report right click in the solution exlorer...

Update DimWarehouseT2

Set CurrentStatus = 'H'

Where

CurrentStatus = 'U'

Insert Into DimWarehouseT2

(

WarehouseCode,

WarehouseDescription,

WarehouseName,

ValidFrom,

CurrentStatus

)

Select

Detail.WarehouseCode,

Detail.WarehouseDescription,

Detail.WarehouseName,

Detail.ValidFrom,

'C' As CurrentStatus

From

[CurrentDetail]..DimWarehouse As Detail

Left Outer Join DimWarehouseT2 As Presentation On

Detail.WarehouseCode = Presentation.WarehouseCode

Where

Presentation.WarehouseCode Is Null

Or Presentation.CurrentStatus = 'U'

Use Presentation

Update DimWarehouseT2

Set ValidTo = DateAdd(s,-1,Cast(Cast(GetDate() As Varchar(12)) As DateTime)),

CurrentStatus = 'H'

From

[CurrentDetail]..DimWarehouse As Detail

Inner Join DimWarehouseT2 As Presentation On

Detail.WarehouseCode = Presentation.WarehouseCode

Where

Presentation.CurrentStatus = 'C'

And (Detail.WarehouseDescription Presentation.WarehouseDescription

Or Detail.WarehouseName Presentation.WarehouseName)

Hi,

When I first saw the SCD control I was excited and thought it would save me some time. After trying to use it I found the resulting package complicated to...

Use Presentation

If Not Exists(Select * From sys.tables Where name='DimWarehouseT2' And type='U')

Begin

Create Table dbo.DimWarehouseT2

(

WarehouseKey int Identity(0,1) Not Null,

WarehouseCode NVarchar(16) Collate database_default Null,

WarehouseDescription NVarchar(64) Collate database_default Null,

WarehouseName Nvarchar(96) Collate database_default Null,

ValidFrom datetime...

Hey Mani,

They are definately OLEDB connections.

I'm having a rest from this problem until the development is completed. This will give me a chance to investigate this further having full...

Hi,

I have had this problem recently and found it quite frustrating. Check out the following KB.

http://support.microsoft.com/kb/194124/EN-US/

I have also seen a solution where are user has modified the spreadsheet...