asked on

SQL Server 2K DTS package SQL Timeout expired

I've got a dts package which is intended to port data from one sever to another, the package used to work but now when I click on the Parse Query button I get the following error message:

OLE DB Error Trace (OLE/DB Provider'SQLOLEDB' IDBInitialize:: Initialize returned 0x80004005:
[OLE/DB Provider returned message: Timeout expired]

Are there any settings I can change to circumvent this error. Both the source and destination server/databases are visible

SOLUTION

Mr_Peerapol

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Natchiket

ASKER

> From one server, are you able to connect to another sever just to query some data?

Actually no ... when i try this in Query Manager from VLA62 I get the same error
SELECT TOP 1 * FROM CBASQLTN1.AMLS2LiveCopy.dbo.MOVMovement

So... looks like there's some other factor

Mr_Peerapol

Did you try executing DBCC TRACEON (7300, 3604) before running your query ?

Natchiket

ASKER

This

DBCC TRACEON (7300, 3604)

SELECT TOP 1 * FROM CBASQLTN1.AMLS2LiveCopy.dbo.MOVMovement

Gives the following

Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Timeout expired]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005: ].

ASKER CERTIFIED SOLUTION

chhapia_chintak

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Natchiket

ASKER

Thanks but the problem still remains