Re: API in VB code is rolling back SQL import but wizard does not

Tech-Archive recommends: Fix windows errors by optimizing your registry

THANKS! This worked!!! Now, what is an optimal InsertCommitSize?
Some of my input files and databases can be quite large, upto 2 million
records.

Thanks again, Elizabeth


Darren Green wrote:
> In message <1115669677.267036.93740@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
> ezelasky@xxxxxxxxxxx writes
> >I have a DTS package in visual basic that was created via the DTS
> >wizard and it rolls back or empties the SQL table when a laod
failure
> >is encountered even though I have the following property set:
> >
> >oStep.RollbackFailure = False
> >
> >This doesn't happen in the DTS wizard, I get a partial load on the
> >table with the data before the row with the corrupt data is
> >encountered. I need it to not happen in the VB code and I am
wondering
> >why the wizard generated VB code doesn't do this.
> >
> >What other properties must I set?
> >
> >Thanks!
> >
>
> Do you have different transaction options set? Look at the insert
commit
> size for the DataPump. If no rows have been committed, then you are
not
> going to get rows left after failure.
>
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
>
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org

.

Relevant Pages

  • Re: Moving a access97 database to sql server 2000 version
    ... There is an upsize wizard but if all you want to do is take across structure ... A very good Access developer and SQL Server ... www.SQLDTS.com - The site for all your DTS needs. ... Is there any upsizing wizard for the above verisons. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS with VB.NET
    ... >I want to create a startup package using the DTS Wizard, ... Converting a DTS Package from Visual Basic 6.0 to Visual Basic .Net ... Darren Green (SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase to SQL
    ... Not using the wizard. ... in full which in turn allows you to import/export many tables or it expects ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • Re: dts package and t log
    ... INSERTING and UPDATING is not necessarily committed straight away. ... Default DTS says "Only commit the rows after the last one has gone through". ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • Re: Error
    ... DTS is Data Transformation Services, which is what is used for the database ... copy wizard. ... You mention that you have SQL Server 7 installed on NT 4, ...
    (microsoft.public.sqlserver.connect)