General problem is how SSRS renders HTML (not so good).

My suggestion is to set cell properties “can grow” to “no” and find right ratio between cell/row high and font size....

P Jones (3/12/2010)

---

so you simply need a...

I think You was lucky when export or import succeeded.

Wizard creates one DataFlowTask with two sources and destinations (same for export and import). Sources work parallel and sometimes "orders"...

Elliott W (3/9/2010)

---

I have done something similar in the past only on the input collection. The problem was and is that there is no enumeration of the column list...

Hi,

username/password for ftp site should be in configuration file. I hope that I hit an answer 😀

I have almost same situation. Store manager can see only own store, regional manager few...

Hi,

If you create table with two columns sometable (domainusername, salesterritory) you can catch available territories for user logged on.

Create dataset for populating parameter values, query should be: select ...

Hi,

From my experience there is no help :crying:

SSRS works under IIS and this issue should be solved with "keeping alive" IIS.

Other solution is making *.rdlc reports (if they are part...

Hi,

You can do that using export wizzard from Mamagement Studio. Also, wizard can create SSIS package. Doing that way it will be fast and clean 🙂

Hi,

"Excel Destination" takes format from last row used. Preformating is possible using templates.

Little example here:

http://msbiblog.spaces.live.com/blog/cns!3738F9E9EADAAE6A!148.entry

Question was:

"How do...

Hi,

First create excel file and make connection and then change property of "Excel Connection Manager" DelayValidation to True.