Here's a starter query.

SELECT DISTINCT j.name

FROM msdb.dbo.sysjobs j

INNER JOIN msdb.dbo.sysjobsteps js

ON j.job_id = js.job_id

WHERE js.subsystem = 'SSIS'

This relies on the job step having been defined as an SSIS task. ...

You could use a linked server from the SQL Server side and retrieve the data from Oracle via stored proc. In that stored proc join the data and then...

big show

You're welcome to post your more simple elegant solution. As was stated in the onset of the...

If somebody out there knows how to do that, they are welcome to post it. I don't have...

Thanks Koen

Unless you are using shared datasets, it looks like you will need to get that info by extracting the xml for each report and querying the xml.

Here is a blog...

I can see size as a cost measure. We charged at a prior place for amount of time spent supporting the user base and projects along with routine maintenance.

You are welcome.

sqlfriends (2/23/2012)

---

This other server that is your report server is different. In that case, you need to make sure you have your reporting services key backed up (can be...

It seems you are looking for a scale out deployment.

Here is some info and references.

http://technet.microsoft.com/en-us/library/ms156453.aspx

yes

Also I have another server, which hosts reporting server and its databases, I need to upgrade...

If you have a new box, install SQL 2008 R2 on that box. Restore the database(s) from backup. Then change the compatibility level and test the application against...

Welsh Corgi (2/22/2012)

---

SQLRNNR (2/22/2012)

---

Welsh Corgi (2/22/2012)

---

Does anyone have both SSRS 2005 & 2008 in their Corporate Environment?

If so how do you mange it?

I want to move to 2008R2 but not...

Welsh Corgi (2/22/2012)

---

I was thinking, just because the back end databases are moved to SQL Server 2008 R2 does not prevent me from creating SSIS & SSRS Packages using BIDS...