Re: Automatic reports?

I'm quite fortunate in that I have SQL experts in my company to do
this... but when we need data from 1 SQL database to be imported into
another, we just tell the SQL team--and those wizards figure it out.
I know it's somehow scheduled within SQL. I realize this information
is not extremely useful; but perhaps this will give you a different
direction to search. Instead of searching on "how to do this with
sms", perhaps "how to do this with sql" ? I am assuming that both
databases are within the same organization.

I know we have 1 routine setup like this. Our internal helpdesk
ticketting system (sql on the backend) pulls data from SMS to populate
the helpdesk systems' hardware tables and linking hardware to users.

If that is not an option, may I suggest the book "SMS 2003 Recipes" by
Greg Ramsey and Warren Byle? Page 267, topic 8-10 "Automatically
Exporting Report Results" sounds like exactly what you are looking
for.

On Sep 3, 4:24 am, "Mathias" <maha.nos...@xxxxxxxxx> wrote:
I'd like to schedule the generation of a report and get the output as a CSV
file. Is there a smart way to do this? My idea is to somehow get a vbscript
to ask the SQL-query and then save the result as a CSV-file. But perhaps
there's a smarter way?
The CSV file is going to be imported into another DB afterwards.

//Mathias


.

Relevant Pages

  • Re: Relational database & OO
    ... And when was the last time you saw an RDB that stored a telephone ... The modern relational theory permits to store values of user-defined type: ... Neither do the relational model or SQL. ... Your comprehension of the SQL database performance is not good. ...
    (comp.object)
  • Event log errors after moving sharepoint 3.0 database
    ... After following a procedure to move the location of the SQL databases from ... SQL Database 'WSS_Content' on SQL Server instance ... The local computer may not have the necessary registry ... information or message DLL files to display messages from a remote computer. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: ISA Log to SQL Database Question
    ... I am actually logging to an Access DB and the logs had grown to over 2 GB. ... The MSDE that comes with ISA or the real "full" MS SQL ... >> I have a question about ISA Logging to a SQL Database. ...
    (microsoft.public.isa.configuration)
  • RE: Automate Active Directory User Maintenance
    ... Hmmm...I know Quest has an ID management tool as well, but they are pricey. ... We've set it up for a client where the information is read from a SQL table ... could it evaulate the users in the SQL database ...
    (microsoft.public.windows.server.active_directory)
  • Re: Automatic reports?
    ... but when we need data from 1 SQL database to be imported into ... we just tell the SQL team--and those wizards figure it out. ... ticketting system pulls data from SMS to populate ... Schedule this url using scheduled tasks en internet explorer. ...
    (microsoft.public.sms.inventory)
Loading