Date:         Wed, 18 Jan 2006 16:59:06 -0500
Reply-To:     Kelly Kieler <kelly.kieler@CUNAMUTUAL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Kelly Kieler <kelly.kieler@CUNAMUTUAL.COM>
Subject:      Loading to SQL Server via Proc Append

Hello,
  I am updating a SQL Server 2000 table via Proc Append using OLEDB
connection.  I load all columns except for the tables ID column.  I am
letting SQL Server create that.  The table loads but gives me a warning
message of WARNING: Variable Fact_SKEY was not found on DATA file.  I am
using the following Options:  BULKLOAD=YES BL_KEEPIDENTITY=NO
IGNORE_READ_ONLY_COLUMNS=YES.  The batch job loads all the records but
then abends with a U0009.  Does anyone know of a system variable that I
can reset so that the job doesn't abend?