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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Getting ADO Timeout Error- Deferred Page Can Not

Author  Topic 

Scottjohnie
Starting Member

1 Post

Posted - 2005-11-25 : 14:30:04
When I open up one of my Local Packages / Transform Data Task Properties/ and select Build Query it brings up the Diagram Pane along with the Select/From/Where statements. Without even changing anything, I 've selected the "OK" button and it processes for about 30 - 60 seconds and then returns with a "ADO error: Timeout expired".
"Deferred prepare could not be completed".
I can execute the DTS Package and it runs ok along with the appropriate data. I need to add addition code to this query but the error issue looses the added logic. Any help would be greatly appreciated.
   

- Advertisement -