I have a large file to be processed. I would like to split the files
into say 80000 records in each file to manage the size of processing.

Please kindly share the code or procedure to split a file into
manageable sizes and handling the resulting split files from DTS.

Thanks
Karen

karenmiddleol (AT) yahoo (DOT) com wrote:


http://www.visualbasicscript.com/m_23627/tm.htm

(but not in the context of DTS - sorry)

Because in the initial read you will have no clue about the records
best is to use the file size.
-------
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/

Because in the initial read you will have no clue about the records
best is to use the file size.ok again you have a logic when you should
know you have reached half and ensure that you have noit read half
record data.
-------
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/

Hello karenmiddleol (AT) yahoo (DOT) com,

Is this a large text file coming in to you?

Performing an intermediary step like this will do nothing for performance
of the package. BULK INSERT along with no indexing on the target table and
no constraints usually handles the job just fine. I BULK in files of more
than 17,000,000 rows without a problem. If you want to perform some AX stuff
on the rows as they come through then splitting this up will not help either.
They will still all need to be processed.


Allan