StevenMarks Posted May 21, 2013 Share Posted May 21, 2013 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 https://forums.phpfreaks.com/topic/278242-csv-file-ftp-upload-and-import-to-mssql/ Share on other sites More sharing options...
StevenMarks Posted May 21, 2013 Author Share Posted May 21, 2013 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. Link to comment https://forums.phpfreaks.com/topic/278242-csv-file-ftp-upload-and-import-to-mssql/#findComment-1431389 Share on other sites More sharing options...
jazzman1 Posted May 21, 2013 Share Posted May 21, 2013 Your question belongs to "Freelancing Section", I think Link to comment https://forums.phpfreaks.com/topic/278242-csv-file-ftp-upload-and-import-to-mssql/#findComment-1431391 Share on other sites More sharing options...
Barand Posted May 21, 2013 Share Posted May 21, 2013 One option is BULK INSERT command. If you want to automate it, look into Server Integration Services Link to comment https://forums.phpfreaks.com/topic/278242-csv-file-ftp-upload-and-import-to-mssql/#findComment-1431395 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.