Calling Proc Multiple Times

• Ghanta

  Hall of Fame

  Points: 3999

  More actions

  April 9, 2009 at 3:22 pm

  #201905

  Hey Guys,

  Need your suggestion on this. Format file and file will be ftped to a certain location on random times. I need to create a SP to pick the format files and create tables based on that format files and data send with format files. I guess file names and format files should be same with different extension and I can use the file name as the table name. I need suggestion on couple of things...

  1. How can I use the format file and create tables based on that and do a bulk insert? 2. How can I run this Proc every 10 minutes and run it multiple times so that multiple files are loaded at once?

  I will be using separate SP to get files in the directory and insert the list in a table with couple of flags so that the files already in process is not touched again for load part... Any suggestion is appreciated.

  Thanks... I may not be that clear about what I am asking... I will add more. Thanks!

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9149

  More actions

  April 11, 2009 at 10:20 am

  #976109

  Hi

  Can you give us sample of "Format File"

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers