Hello, I will be outputting the contents of a table to a file. I would like
to log, in a table, the status (failed/success) of each row. Each row has a
column with a unique number in it. This is the value I would like to output
to the logging table, along with the success or failure message.

Can someone explain how to do this? My initial thought was to do this with
an ActiveX task and the File System Object, but I am wondering if there is a
better (or easier) way. Thanks!

Ric

Is the status (failed/success) a column in the table? Something you
can derive from a table row?

If you can write a SELECT that returns the unique number and the
status as a two-column result set, I consider making that SELECT into
a VIEW and using DTS (if you are using SQL Server 2000) or Integration
Services (2005) to extract from the view.

Roy Harvey
Beacon Falls, CT

On Fri, 4 Aug 2006 13:04:02 -0700, Ric <Ric (AT) discussions (DOT) microsoft.com>
wrote:

Sorry, place references to TableA with TextFileA.

"Ric" wrote:

No, there is no status, per se. Eseentially what I want to do is a double
insert. One insert into TableA, and another into TableB. The row being
inserted into TableB will be the same row that is being inserted into TableA
with the addition of a success/failure column that indicates if the insertion
into TableA succeeded or failed.

Ric

"Roy Harvey" wrote: