Post reply

Today's baseball game (or importing data).

  • June 4, 2010 at 9:29 am

    #221861

    Today's baseball game will be played using sql and in one of 2 stadiums - either with "asp.net" or with "VisualBasic." I've never been to either of these 2 diamonds.

    On my team I already have 2 players:

    "Lead off hitter": A vendor of data that sends 3 excel spreadsheets daily. Each *.xls file is sent as an attachment to an email.

    "Batting 2nd": An application that strips off these attachments and saves the files in a specified directory.

    To win the game, I need help to draft at least 2 more players:

    Batting 3rd": An application that imports the vendor's data from the specified files/location to a sql table. This application needs to be a scheduled event OR executed on demand by a user.

    Batting in the all important 4th spot": I need a front end application that will accommodate the above and is easy and quick to develop. I've been looking at and thinking about either asp.net or vb.

    Please help. Thanks in advance!

  • June 4, 2010 at 10:42 am

    #1176636

    I’m not 100% sure what you mean by a “front end application that will accommodate the above”, but I think SSIS (SQL Server Integration Services) will accomplish what you are looking for. It definietly has the ability to pull in data from a spreadsheet into a SQL database and can be scheulded as a SQL Job. The application you use to design an SSIS package is SQL Server Business Intelligence Studio, which is basically Visual Studio.

  • June 4, 2010 at 11:56 am

    #1176672

    Randy100 (6/4/2010)

    "Batting 2nd": An application that strips off these attachments and saves the files in a specified directory.

    Use this same application to fire off the SSIS package that will do the actual data import plus archive the file plus whatever else you need all in the same package.

    -or-

    You could use this same application to parse out the files into the database. Usually using SSIS would be better but there are times when that may not be the case.

    Either way, do either of these and you don't need any additional steps.

    └> bt


    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply