I am trying to warehouse a simple table (following the guidelines set
in the OpenInsight 3.7 Microsoft SQL 7.0 Knowledge base article).
I have no problems warehousing the data if I chose to drop/create the
table. If I choose to not drop or clear the table (what I need to be able to do) it will not work,(error messages in error log "Error processing "record number") I have searched other postings and followed the suggestions therein.
The line that creates the problem in the warehouse program is:
Ret=DSMethod(Handle[i], DS_EXECUTE$)
I used Cameron's suggestion to capture the error:
DSMethod(Handle[i], DS_GETERROR$, "","","","",Text)
Send_Info("WP Error: ":TEXT)
And the error I get is:
A non-null DataSet column can not be bound to a nullable result set column
The question I have is, what is the command( Ret=DSMethod(Handle[i], DS_EXECUTE$) doing? is it trying to use the data set to do
a select on the SQL table?
Any help/suggestions would be appreciated.
TIA.