SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Wizard boxhead's Avatar
    Join Date
    Feb 2004
    Location
    UK
    Posts
    1,040
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    automated .csv advice

    I need to send a csv file to a company from data gathered using various stored procedures on our db. There will be a monthly full export of all records and a weekly export of new/updated records.

    What is the best way to go about this? Should i write a web service with two methods and set up two windows scheduled task to run the web service? Is it better to get MS SQLServer to export the data as a csv file or get .net to build the csv itself?

    Any help/guidance/ideas greatly appreciated.

    cheers
    monkey - the rest is history

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,576
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Are they picking up or do you need to deliver?

    Anyhow, in terms of generating the CSV files, Sql Server's SSIS should work if you are just executing SQL statements to get the data. If the data is a bit more complex check out FileHelpers to handle CSV generation. I don't see much of a need for a web service here unless that is how they want to grab the files.

  3. #3
    SitePoint Wizard boxhead's Avatar
    Join Date
    Feb 2004
    Location
    UK
    Posts
    1,040
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by wwb_99 View Post
    Are they picking up or do you need to deliver?

    Anyhow, in terms of generating the CSV files, Sql Server's SSIS should work if you are just executing SQL statements to get the data. If the data is a bit more complex check out FileHelpers to handle CSV generation. I don't see much of a need for a web service here unless that is how they want to grab the files.
    We are going to deliver. I thought this may be the case - cheers for yuo help
    monkey - the rest is history

  4. #4
    SitePoint Enthusiast
    Join Date
    Jul 2008
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    in your case i think it is better to do it in SSIS. It is same like you are doing code in VS
    http://www.fla-shop.com - Interactive maps for websites
    Flash Maps for web developers


Bookmarks

Posting Permissions

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