Could you please share your inputs about this..

Thanks

I'm getting the below error when I run the SQLAgent job:

Message

Executed as user: ABC\mssqlsrv. The process could not be created for step 1 of job 0x5003F9CB7CA4CB469EFBE981D011B942 (reason: The system cannot...

Thanks Dan,

I downloaded the SQL Server 2000 DTS Designer components under the heading SQL Server 2005 Feature Pack from the below link on the server where SQL Server 2008 x64...

Hi Dan,

DTS is supported on SQL Server 2008 & SQL Server 2008 R2 too.

http://msdn.microsoft.com/en-us/library/bb500440.aspx

Go through the the above link..

Thanks

This is worked after performing the following:

Install SQLServer2005_BC_x64.msi after installing SQL Server 2008 x64.

While installing SQLServer2005_BC_x64.msi, just select the 1st option "Data Transformation Services 2000 runtime"

even though the MS link...

Hi Kent,

I have the same issue after moving the DTS package from SQL Server 2005 to SQL Server 2008. Could you please advice me what you did to resolve the...

I did not find a solution yet..I appreciate if anybody have the same problem and has a fix for this

Thanks

Is the below SSRS configuration correct? please advice me

SQL Server 2005 Reporting Services is installed on Server A and it's databases on Server B.

On Server A, All the reporting Services...

Have you looked at the TSQL to optimize the code? The problem you are encountering seems to be a problem in a poorly written query. You need to check the...

here is the whole scenario:

SQL Server 2005 Reporting Services is installed on Server A and it's databases on Server B.

On Server A, All the reporting Services settings are set to...

I have verified the failed reports but i did find the report INCOME REPORT in failed reports list.

But I did see the report INCOME REPORT running while blocking...

Hi,

I got the blocking again from report server. When blocking occured, I logged into the report server & at the same time a log file was generated as below. From...

So the end user runs a report, and the above query is what is being executed?

Or is the above query being executed by something else (like a system job) and...

You need to find what is causing the query you pasted to execute. Find what is causing that query to run, and then change it so that query is only...

the blocking is from Reportserver NOT from Oracle database.

Are your users running their reports from snapshots?

Is a new snapshot generated each time the run a report?

Is the snapshot cleanup fired...