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
 SQL Server Development (2000)
 DTS tasks run fine until I string them together?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-25 : 11:59:25
Mark Workman writes "I'm running some DTS pull's from Informix and combining the data from 7 databases to 1 SQL as a pseudo-datawarehouse. All the packages run fine individually, but when you string them together they bomb out. It's seems to be an issue of giving the server a little time after each package to write all the records and such. What would be the easiest way to get sql 2000 to wait for a few min between each task without scheduling them separatly?

Mark Workman"
   

- Advertisement -