Limitation on the number of files

• touchmeknot

  SSCommitted

  Points: 1769

  More actions

  October 26, 2011 at 11:46 am

  #262091

  Hello there,

  I am trying to create many XML files to File system, by single call to a stored procedure. The procedure fails and it can generate only x no of files at a time. x is around 70-80. Is there any way, to create 10000 files or call the procedure multiple times ?

  I tried looping and placing a delay, but that doesn't help. It starts giving error messages, after generating 70-80 files.

  Thanks in advance!

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  October 26, 2011 at 11:55 am

  #1399830

  What are the error messages you are receiving?

• touchmeknot

  SSCommitted

  Points: 1769

  More actions

  October 27, 2011 at 9:29 pm

  #1400484

  Thank you Lynn.

  The error is (after few files are generated):

  Msg 50000, Level 16, State 1, Procedure dbo.WriteFiles, Line 51

  Error whilst opening the File System Object

  The line has a declaration, so it is not the correct line #.

  I am using OLE automation procedures to write the files: sp_OACreate, sp_OADestroy etc.

  Thanks again!