January 14, 2013 at 5:58 am
This must be possible but never looked into.
At the Moment I have some FTP software that every hour checks a folder location for a file and then copies and imports it into the db etc.
I would like to have say the client software push the data to the location and this is the part I haven't a clue about, the client software tell MSSQL to execute a stored procedure or a vbscript to import the file and do whatever is necessary.
what different ways can this be done, just an area I know next to nothing about.
thanks
Jasemilly
January 14, 2013 at 6:08 am
I would say this is a task for SSIS.
Use it to download the files from the FTP server and then if it downloads any execute a for each loop to import it into SQL.
January 14, 2013 at 6:30 am
Hi Yes I am thinking SSIS.
What I am thinking though is data collection in the field the user uploading the file to location and then the application telling SQL something in the folder for it too process. I wold like to something a little more efficent than a routine constantly checking a folder to see if something to do.
thanks
January 14, 2013 at 6:32 am
That would then call for something to be coded in the app which will FTP up the file to a specific location, then connect to SQL and issue something like a bulk import command.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy