Adam,

thanks for the reply, but I think you're referring to creating reports using BIDS, not Report Builder which is an application for creating reports from the Reporting Services webpage. If...

The resolution to the problem is to set-up the SQL Agent job step as a Operating system (CmdExec) and in the command line use a statement similar to the one...

Re-installing SQL Server 2005 64-bit and applying SP2 solved the problem.

Thanks for feedback

Thanks for the reply.

It is an X64 server

The package doesn't fail completely and performs the following steps:

1. Create table in SQL Server 2005 database (this works)

2. Run query to retrieve...