In a message dated 3/14/2003 11:06:58 AM Eastern Standard Time, [EMAIL PROTECTED]
writes:
> %%email.unsub%%
>
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription se
Forgot to mention...in the stored procedure you might want to wrap all
the update/insert/delete code inside a transaction. That way if for
some reason it fails, it will roll the SQL table back to the way it was
before and all you'll need to clean up is the temp table.
Tim
Stephen wrote:
I am porting over some information from an Access 97 DB to MSSQL 2000
and am using scheduled DTS (data transformation services) to do it.
Problem: on the first run, it creates the table fine, but when executing
manually or on a schedule, it does not update the existing table... Th