importing data remotly executing.

• jason-810420

  Valued Member

  Points: 56

  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

• Ant-Green

  SSC Guru

  Points: 113537

  More actions

  January 14, 2013 at 6:08 am

  #1576853

  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

  Valued Member

  Points: 56

  More actions

  January 14, 2013 at 6:30 am

  #1576858

  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: 113537

  More actions

  January 14, 2013 at 6:32 am

  #1576859

  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.