Hi;

I want to load 36k records into a SQL table from a text file.

The VBscript that I am using loads 6K records before encountering a problem
with
the transfromation.

I have tried using msgBox but this is no way to deal with 30K worth of
records.

Could I run a SELECT to start in a table at 6K records and return a 100 at
a time ?
--
Gordon

Hi,

No sure how much help this would be but you can switch on just-in-time
debugging for DTS. Right Click 'Data Transformation Services' in EM, select
'Properties' and select 'Turn on just-in-time debugging'

Ray

"Gordon" wrote:

Gordon,

If you are loading from a transform data task...look under the options tab.
There you can set a record number to start and end the load on. You could
also pump up the script to stop the loading when the first error occurs and
then dump to msgbox the relevent info. Hope this helps!!

Jon

"Gordon" <Gordon (AT) discussions (DOT) microsoft.com> wrote