OK.

Is it possible to post the exact expression that sets the connectionstring to the Excel file?

Also make sure the Excel file is closed when you run the package.

Yes, use the OLE DB Destination with the Fast Load option in favor of the SQL Server Destination.

What do you mean with "any good articles for 2K"?

Do you mean for...

Are you able to open the Excel Source editor and do a preview of the data?

What do you mean with "job"?

Do you mean an SSIS package or a SQL Server Agent job?

Can you elaborate more?

It first sight this doesn't give a problem. The facts all have the same business key, so only 1 inferred member is generated.

When the SCD2 dimension records...

Did you set the DelayValidation property of the dataflow to TRUE?

Jayanth_Kurup (2/28/2012)

---

There is no substitute for doing proper data quality checks during the ETL. While there is a provision to convert to unknown member during processing of the cube and...

Why are you using ADO.NET instead of an Excel source?

Try putting double quotes around your filepath and around the extended properties:

Data Source="G:\EXCEL TO SSMS\wave2_CM.xls";Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

Can you post the expression?

It would be great if you posted the connectionstrings and the expressions that build them.

Is it possible to post the entire error message?

How are you going to fire the Execute Process Task at the beginning of the package and at the end of the package as well?

Welsh Corgi (2/27/2012)

---

RonKyle (2/27/2012)

---

The join is no more "mandatory" than by a standard OLTP design. But that doesn't mean it's not a good idea.

Why did you opt for a...

How do you populate the datasets? With a SQL query?

Wich data container did you use? Table, matrix, list?

1. Which version of Excel are you using? There are 64-bit providers available for the ACE OLE DB provider.

2. Do you get the error in BIDS or at server? The...