Post reply

importing data remotly executing.

  • 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

  • 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.

  • 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

  • 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.

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

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