I apologies in advance for this rant.
What in the name of all that is holy is up with the error messages in SQL Server 2005 Integration Services!I am doing a large first run of a data load. The third from last task involves a straight dump of 14 Million rows into a table. 9,423,176 rows in and I get:
The attempt to send a row to SQL Server failed with error code 0x80004005
With that everything comes to a grinding halt.
Ok it failed but give me something to work on here!
A google of the error code shows that it has been used by every developer going and relates to everything from Outlook to ASP Pages!
I may as well resort to poking it with a large sharp stick, which is what I want to vigorously do to the people who did the error messaging in SSIS.