Re: SQL JOB Write to a File

From: DraguVaso (pietercoucke_at_hotmail.com)
Date: 06/15/04


Date: Tue, 15 Jun 2004 15:38:22 +0200

Great!! Thanks!!

Related to this: Can I do the reverse thing too? Reading a file and doing
Inserts and Updates to the Database?

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:1c60401c452dd$20ccf6d0$a601280a@phx.gbl...
> Pieter,
> under the advanced tab of the job step you can select to
> pipe the output to a text file. If you want more
> sophisticated formatting options, you can initiate a DTS
> package or even an OSQL batch file from the job.
> HTH,
> Paul Ibison
>



Relevant Pages

  • Update database using DataAdapter for DataSet populated from XML file?
    ... I have an XML file with data which I am reading into a dataset. ... I want to make changes to a table in my database based on values from the dataset. ... These changes can include updates, ... my dataset was not filled using the DataAdapter... ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: how to move location of default database???? plz!
    ... fine, cool about the database, it probably amounts to how much tagging one ... updates - i woulda rolled them all back. ... No recent version of Windows does ... well when you have less than about 50MB to 100MB of free space. ...
    (microsoft.public.windowsmedia.player)
  • Re: Update Sql Server 2000 database from the HP3000
    ... collects those updates via ODBC every 10 or so seconds. ... essentially update the SQL database at the same time as the main ... Authorised and regulated by the Financial Services Authority. ...
    (comp.sys.hp.mpe)
  • Re: Application Speed Problem - VERY weird
    ... MDE front ends not MDB ... If the DB is reading in a lot of records, ... The data is linked with the standard Access "link ... add that we have only ever used the database on Access 2K. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: The right database for the job?
    ... Note that "many updates ... > the programmer that have to fix somebody elses code and/or database ... > devices under its control, it connects to a central "DB server" program ...
    (comp.databases)