Home Forums Data Warehousing Integration Services The process cannot access the file because it is being used by another process - small files are locked a bigger one works fine RE: The process cannot access the file because it is being used by another process - small files are locked a bigger one works fine

  • June 11, 2013 at 12:10 am

    #1622707

    about the StreamReaders : I inherited this project and apparently they are used here because the import is done using SqlBulkCopy which should be faster than a dataflow component especially for bigger files. The files I'm working with right now are smaller test files.