Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Scheduled DTS runs slowly

Status
Not open for further replies.
plsh

plsh

Programmer
Mar 5, 2003
118
ZA
Hi there,

I am having a problem with a scheduled DTS. When I run it interactively on my SQL Server 2000 it runs in a few seconds. It access a txt file writes the data to a table on the SQL Server and then manipulates this data a bit. The thing is once I have scheduled it, it takes about 20 minutes to run. I cannot understand why it suddenly goes from less the 30 seconds to almost 20 minutes.

Has anyone ever had this problem or know a solution

Thanks
 
Sort by date Sort by votes
Not to worry anymore, ended up being poor coding. Problem resolved now.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Fsoumia
  • Locked
  • Question
DTS Logging
Replies
2
Views
159
Fsoumia
Fsoumia
WordTechinc
  • Locked
  • Question
DTS disable Daily Run 1
Replies
1
Views
88
drlex
drlex
Luvsql
  • Locked
  • Question
Errors running scheduled DTS
Replies
0
Views
65
Luvsql
Luvsql
Aluminum
  • Locked
  • Question
DTS Raiserror messages suddenly stopped displaying
Replies
0
Views
75
Aluminum
Aluminum
Azzuri
  • Locked
  • Question
DTS To SQL Server 2008
Replies
1
Views
105
mrdenny
mrdenny

Part and Inventory Search

Sponsor

Back
Top