I'm witnessing some strange behavior while executing a
DTS package that executes a stored procedure on a SYBASE
11.9.2 database. Even though the procedure, if executed
on the sybase server errors out ( trying to insert null
values in not null columns), it does not produce any
error whatsoever on the SQL server side. The package
status is "executed successfully". No matter what the
error is on Sybase side, it is not reflected on SQL
server.
We are using OLEDB connection. This has become an urgent
issue for us. Any help is highly appreciated.

Thanks

NOthing would go to the Sybase error log because it is
not a system error. When we execute the proc on sybase
side it immediatly errors out and prints the error
message "trying to insert null values into not null
column". But we it is executed via a DTS package ( SQL
server 2000), the package executes sucessfully ( of
cource it does not do anything as the procedure on sybase
fails. However if we use ODBC connection instead of OLE
DB then the package also abends and the error is
reported. May be its OLE DB that is the culprit here.
Any workarounds??