DTS and File size

• W R

  Mr or Mrs. 500

  Points: 523

  More actions

  January 24, 2007 at 2:15 pm

  #68180

  Using SQL Server 2000, I am executing a DTS package which looks for a data file. If the file size is 20 MB the DTS grabs the file but if the file size is 80 MB the DTS does not grab the file. I was wondering if there is a server setting that dictactes the filesize of data file that DTS can work with.

  Thank you.

  -W R

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 24, 2007 at 6:25 pm

  #685397

  I don't think there is any size setting in dts and limitation of the file size...

  I have uploaded the data from >100 MB files many time...

  Try to log to dts execution to see if you get any info...

   

  MohammedU
  Microsoft SQL Server MVP

• R Tierney

  SSC Enthusiast

  Points: 134

  More actions

  January 25, 2007 at 9:24 am

  #685608

  I've imported 3GB files without problems. 

• Deadwood

  Mr or Mrs. 500

  Points: 522

  More actions

  January 25, 2007 at 12:30 pm

  #685670

  I have loaded 200GB in one go using 6GB files without a problem

  Thanks