Jump to content

CSV file FTP upload and import to MSSQL


StevenMarks

Recommended Posts

Hi Guys, 

 

Not sure if this is the correct place or if it would be something better done in .net. 

 

I have a requirement at work for a web application that will be hosted on one of our internal servers and do the following: 

 

1. allow users to provide ftp details to a file on a server

2. have the ability to map csv columns to database tables columns. 

3. import the csv file into the mssql table

4. once settings have been entered once through a web browser a scheduled task or something similar would run every day with the settings that were supplied and download the new file and import it to the table. 

 

Basically it is a stock file supplied by our suppliers ftp feed that needs importing automatically into our mssql database, either by an application or a web application. 

 

any guidance would be appreciated.

 

Steve

Link to comment
Share on other sites

We need a way to allow web visitors to upload files (.xls, .csv, .txt) to our server, do any field mapping that is necessary, and then import data into MSSQL 2008.

 

once this has been done once it would automatically happen every hour. and the user could login and change settings if required. 

Edited by StevenMarks
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.