Reset Excel Destination for Error Logging

I am using sheets in an Excel spreadsheet to receive redirected error rows. The trouble is that it keeps appending the rows to the bottom of the sheet - even if I delete the rows in the spreadsheet. If I remove the spreadsheet all together then I need to set-up the Excel Desitnation Sheets again.

Each time I run the Control Flow I would like it to be removing old log entries and writing in the new ones.

There must be an easy way?

Unfortunately the Excel driver does not support anything like TRUNCATE TABLE. Even if you opened Excel and cleared the contents of those rows, the driver would still see them as "used" ... the only solution is to delete the rows themselves from within Excel. And you would want to check the range definition to make sure that you were in fact deleting all the rows in the range.

Of course the cleaner solution would be to drop and recreate the table. You could use an Execute SQL task for this purpose, and probably get one of the SSIS components to write the SQL for you to copy and paste in.

-Doug

required software needed by User to look at SSAS 2005 Cubes in Excel 2003

I am addressing what I consider to be somewhat of a problem. We have built some SSAS Cubes in SQL Server 2005. If I understand this correctly, if our Customer wants to slice and dice one of our Cubes inside his Excel Pivot Table he must:

1. Install XML Services (MSXML) 6.0 è (as a prerequisite to the 9.0 OLE DB Provider install)
2. Install Analysis Services 9.0 OLE DB Provider.

Of course, the above is in addition to the need to have MS Query installed. Also, the above premise assumes that the User/customer is not on the SQL Server box.

Is this true?

The requirement of XML Services is the surprise. Why is this needed for everyone?

Thanks in advance for your help in answering this question.

Mick B

Hello! Regarding point 1 and 2 all clients need this unless the users connect with a third party middleware like ProClarity Analytics. But then these users works with designed reports, Ad hoc conenctions directly to the cube will require 1 and 2.

The user needs to belong to a group or account with permissions on the server running SSAS2005(Analysis Services). It has nothing to do with SQL Server 2005 database permissions.

SSAS2005 uses XMLA for communication and that is why, I guess, that you will need MSXML 6.0 .

HTH

Thomas Ivarsson

|||

Thanks Tom. I was looking for that confirmation. I am envisioning one or more Finance User running our Cost Cubes with Pivot Tables. They have to have all this additional software installed before they can use the Cubes.

As a developer I had everything on my SQL Server box so it did not hit me that Users would not have what they need. The Excel add-in was obvious.

Again, I appreciate your response.

Mick

ReportWriter - Soft Artisans

Anyone have any comments on using SoftArtisans ReportWriter that allows
Word/Excel users to write reports and publish to Reporting Services?
Is it very expensive?
is it worth it?"dm1608" wrote:
> Anyone have any comments on using SoftArtisans ReportWriter that allows
> Word/Excel users to write reports and publish to Reporting Services?
Ha! Funny, see a few subject headings down from this post regarding "Excel
reports to RS."
> Is it very expensive?
>
Yes.
> is it worth it?
>
Not really sure yet. I'm asking the same question, although in finer
granularity.
All the best!
Greg--|||"dm1608" wrote:
> Anyone have any comments on using SoftArtisans ReportWriter that allows
> Word/Excel users to write reports and publish to Reporting Services?
> Is it very expensive?
yes, it is expensive.. 7.500 Euro per cpu
> is it worth it?
no, you must redesign all your reports using ms word with the softartisans
addin, if you want to export the reports to word...
And by the Way, i mean the Support by softartisans ist very bad|||So we have SQL Reporting Services in SQL 2000 and 2005. The feature matrix
on SQL 2005 says rendering formats for output are the same: Excel, PDF,
DHTML, images... but still no support for Word.
Does this mean Microsoft itself is shying away from its own product, Word,
by not offering native support within SQL RS? Is there a new industry
standard in word processing that I need to be looking at?
I find it truly mind-boggling for Microsoft to not export to Excel, XML,
even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
only tool available... ?
Any other products out there?
Thanks,
Andrew Puente
"cwalloch" wrote:
>
> "dm1608" wrote:
> > Anyone have any comments on using SoftArtisans ReportWriter that allows
> > Word/Excel users to write reports and publish to Reporting Services?
> >
> > Is it very expensive?
> yes, it is expensive.. 7.500 Euro per cpu
> >
> > is it worth it?
> no, you must redesign all your reports using ms word with the softartisans
> addin, if you want to export the reports to word...
> And by the Way, i mean the Support by softartisans ist very bad|||And before I get crucified, let me revise my last paragraph:
I find it truly mind-boggling for Microsoft to export to Excel, XML,
even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
only tool available... ?
It's called Proofreading 101. I failed that course, apparently. :-)
Cheers,
Andrew Puente
"Andrew Puente" wrote:
> So we have SQL Reporting Services in SQL 2000 and 2005. The feature matrix
> on SQL 2005 says rendering formats for output are the same: Excel, PDF,
> DHTML, images... but still no support for Word.
> Does this mean Microsoft itself is shying away from its own product, Word,
> by not offering native support within SQL RS? Is there a new industry
> standard in word processing that I need to be looking at?
> I find it truly mind-boggling for Microsoft to not export to Excel, XML,
> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
> only tool available... ?
> Any other products out there?
> Thanks,
> Andrew Puente
> "cwalloch" wrote:
> >
> >
> > "dm1608" wrote:
> >
> > > Anyone have any comments on using SoftArtisans ReportWriter that allows
> > > Word/Excel users to write reports and publish to Reporting Services?
> > >
> > > Is it very expensive?
> > yes, it is expensive.. 7.500 Euro per cpu
> >
> > >
> > > is it worth it?
> > no, you must redesign all your reports using ms word with the softartisans
> > addin, if you want to export the reports to word...
> > And by the Way, i mean the Support by softartisans ist very bad|||I suspect that XPS format and office 12 xml formats will be supported when
released.
--
William Stacey [MVP]
"Andrew Puente" <AndrewPuente@.discussions.microsoft.com> wrote in message
news:1B3A18C9-17C9-4135-B367-5E05253C067A@.microsoft.com...
> And before I get crucified, let me revise my last paragraph:
> I find it truly mind-boggling for Microsoft to export to Excel, XML,
> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be
> the
> only tool available... ?
> It's called Proofreading 101. I failed that course, apparently. :-)
> Cheers,
> Andrew Puente
>
> "Andrew Puente" wrote:
>> So we have SQL Reporting Services in SQL 2000 and 2005. The feature
>> matrix
>> on SQL 2005 says rendering formats for output are the same: Excel, PDF,
>> DHTML, images... but still no support for Word.
>> Does this mean Microsoft itself is shying away from its own product,
>> Word,
>> by not offering native support within SQL RS? Is there a new industry
>> standard in word processing that I need to be looking at?
>> I find it truly mind-boggling for Microsoft to not export to Excel, XML,
>> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be
>> the
>> only tool available... ?
>> Any other products out there?
>> Thanks,
>> Andrew Puente
>> "cwalloch" wrote:
>> >
>> >
>> > "dm1608" wrote:
>> >
>> > > Anyone have any comments on using SoftArtisans ReportWriter that
>> > > allows
>> > > Word/Excel users to write reports and publish to Reporting Services?
>> > >
>> > > Is it very expensive?
>> > yes, it is expensive.. 7.500 Euro per cpu
>> >
>> > >
>> > > is it worth it?
>> > no, you must redesign all your reports using ms word with the
>> > softartisans
>> > addin, if you want to export the reports to word...
>> > And by the Way, i mean the Support by softartisans ist very bad

ReportViewer.LocalReport.Render - PDF filesize over 5 MB

I am testing the .Render method of a local report and can get to export to excel and pdf no problem. My xls file size is under 50 K for a small chart graphic report but every pdf generated tops 5 MB. Is this an issue that an be resolved or a bug in the ReportViewer?

Any solution to this problem? I've got a 10 page report that is less than 1MB in Excel and more than 40MB in PDF!|||

This sucks!

I found this post saying that this is a known problem:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=379152&SiteID=1&mode=1

I have a PDF that renders as 25MB. If you open it in acrobat and save a copy of it the copy is saved as 270KB. 95 times smaller!!!