December 9, 2018 at 10:45 pm
Dear Forum,
I am wanting to capture an error from an "OLE DB Destination".
i.e. to a database table or to a flat file.
I seem to have ErrorCode and ErrorColumn .. and I am getting an error number like -1071607685
I interested in capture of a more meaningful error message.
e.g. a message that contains the database table constraint name that is cause of insert error.
Can someone please point me to an article or a recent/modern existing forum question on this?
cheers, thanks,
Allan
December 10, 2018 at 1:15 am
This is not a solution but a suggestion. If that failed on SQL server would you be able to find out in SQL in which case use the fact you have error'd to retrieve the info. I use RAISERROR() to provide more detailed feedback form Executing SQL stored procs as my source. SQL Server must store the error for you by default somewhere.
M
December 10, 2018 at 5:53 am
allan.ford17 - Sunday, December 9, 2018 10:45 PMDear Forum,
I am wanting to capture an error from an "OLE DB Destination".
i.e. to a database table or to a flat file.
I seem to have ErrorCode and ErrorColumn .. and I am getting an error number like -1071607685
I interested in capture of a more meaningful error message.
e.g. a message that contains the database table constraint name that is cause of insert error.
Can someone please point me to an article or a recent/modern existing forum question on this?cheers, thanks,
Allan
Have a read of this article about getting hold of more useful error info (error column and error description).
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply