Hi
I am designing a DTS package which does a simple transformation task and I want to record the following type of information on transformation errors:
[ul][li]Number of rows returned[/li] [li]Number of errors returned[/li][li]Error reason[/li]
[/ul]
I want to store this information in a table.
I am very new to things like activex scripts and have been trying to use the GetExecuteErrorInfo method of steps but I get a 'Type mismatch' error. Having researched into this I understand that there might be a workaround but it sounds too complicated to me!
To me it seems as if there is such a huge number of ways that error-handling can be achieved in DTS eg SQL code, OLE Automation, log files, Active X scripts etc and I am beginning to get quite confused.![[3eyes]](/data/assets/smilies/3eyes.gif "[3eyes] [3eyes]")
Any help on this would be much appreciated:
Nassy
I am designing a DTS package which does a simple transformation task and I want to record the following type of information on transformation errors:
[ul][li]Number of rows returned[/li] [li]Number of errors returned[/li][li]Error reason[/li]
[/ul]
I want to store this information in a table.
I am very new to things like activex scripts and have been trying to use the GetExecuteErrorInfo method of steps but I get a 'Type mismatch' error. Having researched into this I understand that there might be a workaround but it sounds too complicated to me!
To me it seems as if there is such a huge number of ways that error-handling can be achieved in DTS eg SQL code, OLE Automation, log files, Active X scripts etc and I am beginning to get quite confused.
Any help on this would be much appreciated:
Nassy