"hari" <hari_krishna_v@yahoo.com> wrote in message
news:06e001c36783$2a627c60$a401280a@phx.gbl...
> I am transferring some SQL Server Tables through
> DTS VB Program.
> The transfer is for a particular month's records, from one
> Server(source) to another Server's(destination) database.
> First it deletes the records from destination server
> tables, and copies the records to destination from the
> source server tables. explicitly in VB program(DTS
> program) i assigned this Delete queries and copy Queries.
> There are abount 60 tables that are to be transferred.
> Once the "DTSpackage.Execute" is done, I call another VB
> Procedure where it checks the source records and the
> copied destination side records(for that particular
> month). If the number of records are same at both servers
> then I delete the source table's records. (Actually this
> is like backup(archiving) for a particular month.)
> DTSpackage.execute got error for some tables after
> deleting and copying the some tables due to some fields
> which are not there at destination tables. so it went to
> the package_errorhandler:. but when i checked the source
> and destination tables, DTS didnot copy some of the tables
> which are copied successfully before an error occurred.
> And at source also i didnot find those records and also no
> records at destination for that month. only the procedure
> followed by the DTSpackage.Execute will delete the records
> from source tables.
> i think u understood the question.
> pls response me.