The SSRS engine that renders the reports is basically a web service.

There are a numbers of methods you can use.

Report Server Web Service Methods

You mean "fully justify".

This is not possible (yet) in SSRS.

full justification in reporting services 2008 needed

Yes. Select the text you want right and allign it right.

Select the text you want left (on another line of course), and allign it left.

If both text are on the...

By choosing align right from the toolbar?

(see screenshot in attachment)

edit: you can also modify the TextAlign property

Although the avatar is a bit misleading, Gail is a woman 😉

Use a stored procedure, like I mentioned earlier.

Phil Parkin (11/18/2013)

---

Koen Verbeeck (11/18/2013)

---

I think the limit in SSIS is smaller.

I've had issues with very large SQL statements in Execute SQL Tasks, but they were less...

GilaMonster (11/18/2013)

---

Koen Verbeeck (11/18/2013)

---

Maybe - and just maybe - you might benefit from a (clustered) columnstore index - if you're using SQL Server 2012 or 2014 - because those indexes...

Shadab Shah (11/18/2013)

---

I may be wrong over here but if none index is created on the table it gets stored on heap...

I think the limit in SSIS is smaller.

I've had issues with very large SQL statements in Execute SQL Tasks, but they were less than 64K characters if...

Any source control present?

I believe SSRS will build the report prior to rendering it in Visual Studio, so that's why changes might be persisted.

Anyway, every heard of the undo button?

In theory everything seems to be correct.

Can you supply some screenshots of your package design?

You can script them out. You can either...

You could do an uncompressed back-up/restore.

Or do the data migration in SSIS itself so you can exploit parallellism to the max. (not sure how the copy database task uses parallellism).

ps:...

Wouldn't a compressed full backup/restore have been faster?