SSRS 2008 – Rendering HTML content

Finally here in SSRS 2008 is the ability to render html content in reports. It’s a doddle to do too.   In report design mode : Double click on the cell you want to take the html content. Right click on the cell. Select “Create Placeholder” Select the field from your dataset which contains the HTML…

Upgrading SQL Server 2000 to SQL 2008

Upgrading SQL 2000 to SQL 2008 I’ve got an installation with SQL Server 2000, Reporting Services and several DTS packages I’m looking to move to 2008.   I realise there’s going to be a lot of manual work to do, with the minimum likely to be replacing the DTS packages but I wanted to see how much of the…

Copying SQL DTS jobs between servers

In the past I’ve moved DTS packages directly between servers by saving them to the target server as a DTS package but today had a problem and couldn’t connect to the target server from the source so copied the DTS jobs as files.   Both methods of copying I’ve used: Moving the DTS packages between servers which can…