SSIS and SSRS

Question

SSIS and SSRS

Casper101

Hall of Fame

Points: 3903
More actions
June 12, 2008 at 4:20 am

#188963

I currently have a development box with SQL 2005 and VS 2005.
I have created SSIS packages and SSRS reports using the above.
I was informed today that the live server will be using SQL 2008.
My question is: will I be able to execute the packages I already created, on this new live server?
Will I be able to view my reports on this new server?
I am assuming that with SQL 2008 we will have to have VS 2008 as well? I am hoping that my packages and reports will be converted automatically - and that I won't have to recreate them 🙂
Any info on this would be great!
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

I can't help you with SSIS. I just don't know anything about what's going on there in 2008 yet.

SSRS on the other hand, I've got some knowledge. In addition to testing it out for myself, last night at the Souther New England SQL Server Users Group (SNESSUG), Rob Walters of Microsoft gave us a very thorough overview of SSRS in 2008.

Of course, your existing Report Server probably won't be able to connect to the 2008 server, although you can sure try it out. However, the reports are upgraded automatically for you, but only as you open them in the report editor of your choice. That seemed like the easiest part of the upgrade. Once upgraded, the reports can be run against any prior version of SQL Server, just as you'd expect

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

margo@on2morning.com Say Hey Kid Points: 681 More actions · Answer 2

I've got pretty the same scenario. We have VS 2005-authored SSIS packages and RS reports and currently a SQL2005 db server. But we are planning on setting up a new SQL2008 server. The difference is that for both SSIS and RS, those service components are actually running on our web server that is hosting our asp.net websites, not the db server.

So, I'm thinking swapping out the backend from SQL2005 to SQL2008 should really have no effect on our pkg's and reports...

Thoughts, comments?

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 3

You can run SSIS 2005 and SSRS 2005 with a 2008 database engine - all on the same server. In fact, you can run the database engines in two instances side-by-side.

If you intend to use SSIS 2008, you will need to upgrade your packages. This process consists of opening the package with the BIDS 2008 tools - it will upgrade automatically. There are very few things that don't upgrade completely, anything left will be in the errors/warnings tab and you can easily correct them.

There are few differences that could be much of a problem.