They are just different providers. ADO.NET is the ActiveX Data Object for .NET, OLE DB is implemented using the COM model.

Important points are:

* OLE DB is most of the times...

How did you do the import exactly?

What is the datatype of the column that stored the date and time information?

The problem is that the JET OLE DB provider - used to read Excel files - tries to "guess" the datatype.

It scans the first 8 lines of the column and...

SSRS thinks it does, because you (unfortunately) still have to assign a dataset to it...

The File System Task doesn't even have the horsepower to decently move a file, let alone do something more...

Jack Corbett (3/8/2012)

---

Thanks guys. I got mine about 2 minutes AFTER I posted about it here. Usually it is waiting in my inbox when I wake...

Then why not create a stored procedure instead of trying to bypass security to execute a .sql file?

FunkyDexter (3/8/2012)

---

Sorry but I don't think I've made myself clear. It's not the data I want to share - that's trivial. It's the cube as I've designed it...

Ken Davis (3/8/2012)

---

I want to install 2012 RC0, but only the SSMS. I would also like to keep the 2008 R2 SSMS I have on the machine. Will...

Daniel Bowlin (3/8/2012)

---

The SSIS built in SCD transormation is not very good. I actually had a developer on the SSIS team tell me to never use it. You...

Do you know upfront how many little files you need to create?

Got mine a bit late, but...

+1

Is it possible to modify the stored procedure?

What would have been nice if the role of ValidateExternalMetadata was included in the article and how it can work together with DelayValidation during design time.

For the rest, nice article.