Hi,

looking at the error, it's not picking up the servername correctly, so check the source table column names and inparticular look at step 6 again..

Step 6 - Building The Server...

sounds like you may need something like a pivot table query

Hi Daniel - yeah - it's just the one report and I agree - it should just be straight to Access or better still SQL, but hey ho .... thats...

your best solution would be to create multiple dataflows in the control flow area of your package.

create your first dataflow to move the data to the single table on your...

may just have found my answer :w00t: - but I can't test till Monday:

CSV Device Information Settings: http://technet.microsoft.com/en-us/library/ms155365(v=sql.105).aspx in particular: UseFormattedValues

....if you've had the same issue please let me...

Hi

thanks for the reply. Only snag is I'm not running an MDX query.

In my cube I have set up a drill through action on to drill through on...

You probably have, but have you check the permissions for the abc\rsuser?

What's it being used for - running reporting services?

Yeah, what I mean is IBelieve IIS has settings that can restrict the number of connections to the IIS server/ (be that a reporting services site or some other web...

this sounds more like an IIS setting issue - worth checking that IIS is not restricting the connections.

Updated previous post to be more concise

Lowell,

your post has nudged me in the right direction and I think I've found what I was looking for (as the song goes 😀 )

I need the file versio...

Hi thanks Lowell,

the properties seem to suggest that is for the ODBC driver - or do OLE DB and the ODBC use the same DLL

Gianluca,

Thanks for the post. FYI the only change I needed to make was to the set 'Allow Inprocess' provider option for the OraOLEDB.Oracle provider under linked servers.

Thanks again.

thanks Gianluca - I'll take a look and let you know how I get on

😀

Cool. Nice to see it's been useful and aided your daily routines.

What details are you recording on the physical processors?