Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kingsofleo
Starting Member
7 Posts |
 Posted - 2012-07-19 : 08:46:03
|
And if so can anyone please provide detailed steps on how I would do this or provide a link to a good website that would explain this?I'm a total novice at SQL 2008 so apologies in advance for any dumb questions I might ask  |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-19 : 08:51:59
|
| You can give access to specific reports on the report server website to your clients and give that URL to your clients - so that is one way.You can also embed report viewer controls into an asp.net page. Googling for it, this is the first link that I found, which doesn't seem too bad: http://www.codeproject.com/Articles/195191/Integration-of-SSRS-and-net-using-Iframe-and-URL-C |
 |
|
|
kingsofleo
Starting Member
7 Posts |
Posted - 2012-07-19 : 09:07:09
|
| Sunita you're fast becoming my favourite person in the world ha ha thank you soooooooo much One last thing I don't know if you'd know this but the Data Transformations used in SQL 2000 are the compatible with SQL 2008? We have some "jobs" set up to update certain tables automatically and I was wondering if we can copy them straight over of if SQL 2008 has the same functionality. |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-19 : 10:43:57
|
I don't know the answer to this. But, I can't imagine there isn't a way to migrate DTS packages from SQL 2000 to a newer version of SQL Server. Googling for migrating DTS packages from SQL 2000 to SQL 2008 + msdn gives a lot of seemingly useful links.quote:
Sunita you're fast becoming my favourite person in the world ha ha thank you soooooooo much
And you are very welcome, and you are way too kind  |
|
|
|
|
|
|
Can you publish SQL 2008 reports to the web?