da-zero (3/11/2010)

---

If the data in a column is of mixed datatypes, you should put the IMEX=1 option in your connectionstring.

For example:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source="\\myServer\myExcelFile.xls";Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1";

This will force the Jet adapter to...

The details are in the header because in the past I've found I don't get a response if there is nothing specific to interest. Looks like I need to...

Not a lot of forum interest in this one atm, so I gave up on SSIS.

Just for the record, I've done the whole thing with stored procs. Using the below...

Thanks for all your input, Steve. That's the kind of thing I've been hoping for. I work for a very large multi-national and I'm sitting alone in the...

Thanks for the instructions. I built one dimension and it seemed to work OK, although given I don't understand much of the terminology yet, it asked more questions than...

It was my first cube in SSAS, and I have had to teach myself as I go, but I could not see, and still can't see, an interface that lets...

Just built my first cube in Cognos 8 transformer - that's about a tenth of the time it took in SSAS.

Still much to learn but I won't be bothering with...

Thanks Steve. I went for option 1, using ISNULL and it worked a treat.

I'll give some thought to 'Unknown'. As regards non completion of fields by...

The problem just got worse.

I wasn't running anything but I got a call from Tech Support because the server had gone into overdrive. As soon as I dropped the...

tinku.reddy. Ellen and I are trying to write Excel files on a regular basis. I don't have Office installed on my server, so I can't do any detailed...

I'm pretty sure that what I do is not the best way but if you try it, you should get over that problem.

My template has headings in the first row...

Posted this last week and got no replies, so I thought I'd try again.

Can anyone shed any light on this (I've got to go through the pain again, because I...

That's the thing tho'. I really hate bodging things, and what could be more of a bodge than having to convert a MICROSOFT vb date to a character format...

I'm always cautious with dates because of the US format, and I considered converting the date to character, but that seems pretty naff - get a date, convert it to...

I'm back to this one again. As I said above, I worked around the problem in a previous exercise and haven't been able to utilise the suggestions people made.

Today...