importing data remotly executing.

Question

importing data remotly executing.

jason-810420

SSC Rookie

Points: 36
More actions
January 14, 2013 at 5:58 am

#151165

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

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

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

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.

jason-810420 SSC Rookie Points: 36 More actions · Answer 2

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

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.