Linked servers VS. ODBC connections ???

Tech-Archive recommends: Speed Up your PC by fixing your registry

Looking for your opinions. I have a SQL 2000 server which is used mainly
for reporting on data from an AS400 (transitioning from AS400 to a SQL app
on a different server). There are many ODBC connections each made to link
to a certain data store on the AS400, and then there is a query and/or a DTS
package created to pull data for each report. as we approach 50+ reports
you might be able to see where I'm going. Is there a better way? could I
use one linked server connection to all data stores on the as400, and would
it be a bad idea to consolidate DTS packages,each of which also had it's own
scheduled job??? Thanks for any feedback..


.

Relevant Pages

  • Re: Server Performance Report - Memory in use - showing No data
    ... Please find below the report I received this morning. ... There still isn't any 'Server Specifications' or 'Memory use' data ... click the Backup snap-in in Server Management, ... Critical Errors in Application Log ...
    (microsoft.public.windows.server.sbs)
  • Re: Erroneous E-mails sent entries in Server Usage Report
    ... One of the sbs2k3Sp1 boxes did previously report outgoing messages correctly in the Usage Report. ... I gave up modifying the default recipient policy years ago and now create my own policy on each server before creating users. ... the information "E-mail sent to external recipients" lists *zero* messages being sent by all users other than Administrator. ... Please check the Message Tracking Center. ...
    (microsoft.public.windows.server.sbs)
  • Re: Server Performance Reports broken
    ... I'll try to reinstall R2 and report back on how that goes. ... we cannot remove WSUS from R2 features directly. ... tries to collect WSUS information and WSUS node still appears in Server ... Step 1: Reinstall monitoring component: ...
    (microsoft.public.windows.server.sbs)
  • Re: Erroneous E-mails sent entries in Server Usage Report
    ... As far as I can recall, this problem was not present on my own server before ... did previously report outgoing messages correctly in the Usage Report. ... I gave up modifying the default recipient policy years ago and now create my ... Please check the Message Tracking Center. ...
    (microsoft.public.windows.server.sbs)
  • Re: Server Usage Report
    ... Server firewall to access the Internet. ... Configure ISA Server for monitoring and reporting. ... The SBS Usage report does not pull data from ISA. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)