When I posted this I hadn't been able to shrink the log file. I needed to have the SQL server service running for this, and when I restarted it,...

Hi fstop

I still think my advice on the other thread, to start from scratch, was right, but if you're not used to using SSIS this way, it may be a...

iowaind - You don't have to delete report.xls. Having a file copy task with overwrite set to yes will do it automatically.

fstop - I'm pretty new to SSIS and...

I think I more or less posted the answer to this above.

Use an empty excel file as a kind of template - it will be empty except for the column...

There are some great tips here and thank you all.

The report I've just built is one of around 10 very similar reports, all with 20 pages of charts...

It's an appealing idea, but I think it means either giving ODBC access to the user base, or someone opening the workbook and running the macro prior to delivering the...

Thanks for all the feedback. I've got my first report working, so I'm feeling more optimistic. I did it without Access as well!

I had to pad out line...

I've not tried your suggestion because I can't see how you would get it to write to the right worksheet. Did you first save the workbook with the activesheet...

Guys. I totally agree with you both. Unfortunately, I've had a 5 day training course covering SSIS, SSAS and SSRS. Now I'm on my own - apart...

Think I'm mainly talking to myself here, but its probably worth posting a bit more, in case someone else has the problem.

My report consists of a parent package, a child...

I have raised a new topic on this problem, but haven't been able to resolve it. I have just read this thread tried changing my numeric formats in line...

Thanks for the reply. Can you explain what you mean by editor please?

As far as I can see, the file connection manager couldn't write to my excel template because...

While I was waiting I tried changing the text columns in the data conversion transformation to DT_NTEXT. This got rid of the warnings but when I run the package,...

Thank you for the quick response.

My time dimension has 4 years worth of dates (1461 rows). The columns describe yyyy, yy,mmmm, mm, dddd, dd, weekday, weeknumber, and some other...

I found the probable cause of the problem on the Administering SQL Server forum.

It seems I must get the owners of the remote server to recompile their view, at the...