Dumping incremental changes to textfile

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • charliek
    #1

    Dumping incremental changes to textfile

    I was wondering if there is a way to schedule a tast that will dump a
    fixed width text file of all the new entries in a table. So if I had
    a table with like

    username - varchar(20)
    created - smalldatetime

    I could get a weekly feed each week of all the new users in a text
    file. I know I could write a script that would go through and do this
    by looking at the time stamp, and the last time that the file
    previously ran and get the new dates but I was hoping there was a
    built way to do this. Or perhaps a more elegant solution.

    Thanks,

    Charlie
    Tags: None
    • Simon Hayes
      #2
      Re: Dumping incremental changes to textfile


      "charliek" <charlie_knudse n@hotmail.com> wrote in message
      news:964kpvc52g fj8mp7vf05oktlq uaukcfgdm@4ax.c om...[color=blue]
      > I was wondering if there is a way to schedule a tast that will dump a
      > fixed width text file of all the new entries in a table. So if I had
      > a table with like
      >
      > username - varchar(20)
      > created - smalldatetime
      >
      > I could get a weekly feed each week of all the new users in a text
      > file. I know I could write a script that would go through and do this
      > by looking at the time stamp, and the last time that the file
      > previously ran and get the new dates but I was hoping there was a
      > built way to do this. Or perhaps a more elegant solution.
      >
      > Thanks,
      >
      > Charlie[/color]

      Using a script is fine, or you could look at BCP or DTS as well. There's no
      automatic functionality for this, so you'll have to set something up
      yourself.

      Simon


        Comment

        • charliek
          #3
          Re: Dumping incremental changes to textfile

          On Sat, 25 Oct 2003 14:38:12 +0200, "Simon Hayes" <sql@hayes.ch >
          wrote:
          [color=blue]
          >
          >"charliek" <charlie_knudse n@hotmail.com> wrote in message
          >news:964kpvc52 gfj8mp7vf05oktl quaukcfgdm@4ax. com...[color=green]
          >> I was wondering if there is a way to schedule a tast that will dump a
          >> fixed width text file of all the new entries in a table. So if I had
          >> a table with like
          >>
          >> username - varchar(20)
          >> created - smalldatetime
          >>
          >> I could get a weekly feed each week of all the new users in a text
          >> file. I know I could write a script that would go through and do this
          >> by looking at the time stamp, and the last time that the file
          >> previously ran and get the new dates but I was hoping there was a
          >> built way to do this. Or perhaps a more elegant solution.
          >>
          >> Thanks,
          >>
          >> Charlie[/color]
          >
          >Using a script is fine, or you could look at BCP or DTS as well. There's no
          >automatic functionality for this, so you'll have to set something up
          >yourself.
          >
          >Simon
          >[/color]

          Thanks for the info. I thought that this may be the case, however I
          wanted to make sure that I was not overlooking a easy or more
          efficient solution.

          Thanks,

          Charlie

            Comment

            Previous template Next
            Working...