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)
 Create a DTS package to retrieve records from db

Author  Topic 

verybrightstar
Starting Member

16 Posts

Posted - 2004-03-29 : 11:16:27
hi,
i would like to create a DTS package to retrieve records from database , this records i retrieve is from the error log table ( ERROR_LOG_TB),the scheduler will run at 9 am daily and will retrieve the records if there is a error and the error information will be capsulate and sent through email.
Can i know how to know how to graphically do in DTS ? i am running SQL Server 2000. Is there is reference or tutorial i can refer to ?

Thanks a million if u experts can help me

kt

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-03-29 : 16:31:24
http://www.amazon.com/exec/obidos/tg/detail/-/0735619166/qid=1080595846/sr=1-2/ref=sr_1_2/104-6484327-5551907?v=glance&s=books

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -