Results 1 to 5 of 5

Thread: best way?

  1. Jul 21st, 2003, 06:52 AM #1
    fmardani
    fmardani is offline

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2002
    Location
    London
    Posts
    678

    best way?

    my intention is to check a folder every so often and take the .txt files one by one and transfer the data in the text files into a sql server database table.
    Should I use DTS within vb.net or some other means?
    Thanks
    Reply With Quote Reply With Quote
  2. Jul 21st, 2003, 08:47 AM #2
    Redth
    Redth is offline
    Fanatic Member Redth's Avatar
    Join Date
    May 2001
    Location
    Ontario, Canada
    Posts
    551
    well the best way would be to use a file system watcher, whatever it's called....

    It's just an object from a namespace that you will create, and basically whenever the contents of the directory change (creation, editing, deletetion, etc.) that you've subscribed your watcher to, the watcher will come back and tell you what has happened...

    This is going to be a more efficient way of doing things than checking the directory at a timed interval...


    http://www.vbforums.com/showthread.p...ectory+watcher

    http://www.freevbcode.com/ShowCode.Asp?ID=4841
    Reply With Quote Reply With Quote
  3. Jul 21st, 2003, 09:14 AM #3
    Cander
    Cander is offline
    Banished Cander's Avatar
    Join Date
    Dec 2000
    Location
    Why do you care?
    Posts
    6,913
    Well File system Watcher depends on if he wants to do something right when a change is made to a file or directory. He may want more of a scheduled task thing.
    Stack Overflow
    See the features of Visual Studio 2010 and C# 4.0: The 10-4 show on Channel9
    Reply With Quote Reply With Quote
  4. Jul 21st, 2003, 02:05 PM #4
    fmardani
    fmardani is offline

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2002
    Location
    London
    Posts
    678
    Hi Guys,
    Thanks for the reply but I am really after the actual data transfer from a text file to a table in sql server.
    Should I use DTS within vb.net or some other means?
    Reply With Quote Reply With Quote
  6. Jul 21st, 2003, 07:36 PM #5
    MasterBlaster
    MasterBlaster is offline
    Addicted Member MasterBlaster's Avatar
    Join Date
    Jul 2002
    Location
    Seattle
    Posts
    196
    More info please on or your situation in general. It the text file on the same comp as the database. Is it over a network? Do you want to schedule this. Are you using Com+ and Transactions?

    Personally I like calling dts packages from SQL Stored procedures and calling the sprocs from my middle tier if you absolutly have to run one from your app. It gives you more options if the sheit hits the fan during data transfer. and keeps your data and business logic seperated like they should be in the first place.

    If It is just a Database issue then Create the DTS Package on the database and Schedule it from there.
    Last edited by MasterBlaster; Jul 21st, 2003 at 07:40 PM.
    "And most of the evils of society can, in fact, be cured through information. We have a society that has been disinformed and based on the disinformation has made irrational choices. And that's what I mean by 'ignorance.' People, who ordinarily might be smart, are deprived of the data by which to make a rational decision, don't have the data to do it."
    Frank Zappa
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width