Yes its SSRS.

Thanks for the reply.

I have executed 'include execution plan' its taking lot of time, I guess it would days to execute the query.

.

.

TABLE DEFINITION :

TABLE 1:

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[TABLE1](

[intStatus] [int] NOT NULL,

[intEmailID] [int] NOT NULL,

[intStatusID] [tinyint] NOT NULL,

[AgentID] [int] NOT NULL,

[Updated] [int] NOT NULL,

[Comment] [varchar](1500) COLLATE SQL_Latin1_General_CP1_CI_AS...

stewartc, Thanks for reply. it worked

dateCreation ,intEmailID only these 2 columns have non clustered index.

How can the query be optimized further.

SAMPLE CODE :

SELECT

ltr.intEmailID, ltr.strWanNumber, ltr.intPageCount,DATEADD(hh, 1, ltr.dateCreation) AS dateCreation,

stat.intStatus, ISNULL(stat.strComment, '') AS strComment,DATEADD(hh, 1, stat.dateUpdated) AS dateUpdated, stat.intStatusID,

intIVaultStatus, IVaultStatusDesc,

tmp.strMSPEmailId, tmp.strName

FROM

dbo.TABLE1 AS stat INNER...

The package on both the machines are different but have the same functionality with diffrent sql connection.

the common is the asp.net code on both the machines

DontSaveSensitive

This particular code executes properly when executed on 32 bit windows 2003 with no errors

Its throwing error on 64 bit machine only.

package functionality is importing excel data into sql database......

These are the following Errors :

Error is SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.Error code: 0x80040E4D.

An OLE DB record is available. Source: "Microsoft SQL Native...

These are the following errors I am getting...

2009-09-05 09:55:52 W3SVC1 10.0.0.11 POST /Default.aspx - 80 - 10.0.0.11 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+WOW64;+SV1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729) 401 1 0

2009-09-05 09:55:52 W3SVC1 10.0.0.11 POST /Default.aspx - 80 Administrator 10.0.0.11...

I have kept the SSIS logging on but since the package is not getting executed logging is also not done...

I have put the code under try catch but then also I am not getting any error...

Its really frustrating

Yes I can in Asp.net but the requirement is to be done is Sql server