hi

Is any one knows where can o fond a good material over the DTS Package.

i have some problem regarding DTS Package.
the task is to run 3 different quries in a specific time.
the quries are: 1)find if new lines were added to one DB and if
true move them to DB two.
2)find if new lines were deleted from DB one and if
true delete them from DB two.
3)find if new lines were update in DB one and if
true update them in DB two.
the basic job regards DTS Package is to import/export data.
AM I mistaken when i am trying to use DTS for that,and should i use
regular job for it.

thanks


--
__________________________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

MS Sql Server LazyDBA home page