June 14, 2002 at 9:14 am
I run into a "Multiple-step OLE DB operation generated errors" issue when I execut my DTS package in SQL 2000 environment.
Some information of my DTS package:
- Single "task" transforming data from an Excel file to a table in SQL 2000 database.
- In addition to the above task, my script also will insert a record to a different table within same database instance using a Lookup. This particular Lookup is executed at the end of Main() function, so an ExceptionRow can be thrown when the Lookup failed.
- It works fine in inserting error log to a table in different database instance, but not to the table of the same database instance.
- I am testing the package by clicking the "Test" button in the "ActiveX Script Transformation Properties" screen.
I saw below document related to this issue but maily for SQL 7.
http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=98
Your help is highly appreciated.
Thanks,
June 17, 2002 at 11:08 am
Eventually, I found the cause of the problem. I would like to share this experience with all the techy in the cyber-space, in case other developers
run into the similar situation.
The cause is the mis-matched arguments in the SQL Insert statement of the
DTS Lookup I created. The SQL statement expects 5 arguments passed in by
the calling Script, plus 2 hard-coded values in the statement. However,
during the development I changed the script to pass all 7 values when
making the call to that Lookup.
But I can not explain why the "Multiple-step OLE DB operation generated
errors" was shown for this mis-matched arguments issue. It is very
misleading.
Thanks anyway, for all those who look into this issue, and were trying to
help me solving this puzzle. This P2P community is great!!!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply