Post reply

flat file upload to database using stored procedur

  • May 1, 2003 at 11:20 pm

    #106395

    Hi,

    Can any one send me the Stored Procedure for the flat file data upload to the sql server table? The scenario looks as follows...

    1.File will be received and stored on the FTP server.

    2.Periodically this procedure will check for the unprocessed files.

    3. As each file is processed, records should be created in the database.

    4.Delete the file from ftp server after sucessful load

    Your help here is greatly appreciated..

    Thanks

    Sam

  • May 5, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • May 5, 2003 at 2:11 pm

    #456200

    Try Swynk.com. There are couple of DTS scripts there and procs as well.

  • May 5, 2003 at 2:14 pm

    #456203

    Also try

    http://www.sqldts.com/

    Lots of examples

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

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