Tag Archives: Excel

SSAS / Excel 2010 – An error was encountered in the transport layer

Connecting to SQL Server Analysis Services from a remote domain / login When connecting to SSAS from a different remote domain / login using Excel 2010 where you have set up a windows user at the SSAS server, provided adequate … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , | 7 Comments

SSAS: Excel Data Connection Wizard missing cube(s)

This gallery contains 1 photo.

Have you got missing cubes in your Excel Data Connection Wizard? A customer noticed this yesterday and had spent all afternoon looking for the issue, rebuilding, deploying, processing, deleting and recreating on the server etc. all to no avail. He … Continue reading

Gallery | Tagged , , , , , , , , , , | 4 Comments

Excel Error: There was a problem sending the command to the program

Excel Error: There was a problem sending the command to the program 15 August 2012 If you click on an excel file and get this error instead of Excel opening your document and you have followed the MS link to … Continue reading

Posted in Developer stuff, Other stuff, SQL Stuff | Tagged , , , , , , , | 1 Comment

SSIS export to Excel – Data type issue – “Number Stored as Text”

ISSUE: SQL export to Excel using SSIS We want to export numeric data directly to Excel but the rows come out as “Number Stored as Text” Why is this and how do we get around it so that the numeric … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , , | 3 Comments