Breaking down the error message you have:
The "component "ADO NET Source" (1)"
failed because error code 0x80131937
occurred,
Your ADO data source encountered an error and because you have specified the component should fail on errors (usually the default option) you get this part of the error message:
...the error row disposition on
"output column "Z_ID" (16)" specifies
failure on error.
Therefore your entire package has failed.
Have you recently installed the .NET framework on the same machine as you are running SSIS? If so a possible solution is provided by this MS Fix:
Error message when you run a SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Integration Services package (SSIS) after you install the .NET Framework 2.0 SP2 or the .NET Framework 3.5 SP1: "ADO NET Source [1424]"
I also came across this thread which contains a post stating:
In a nutshell, the cause of the
problem is that .net 2.0 isn't forward
compatible with .net 3.X. what this
means is that applications that are
written to target .net 2.0 won't work
in a .net 3.X environment. an ssis
2005 package is just another .net 2.0
application, so it won't work in a
.net 3.5 environment. fyi: this is
also why ssis 2005 packages won't work
in ssis 2008 unless they're upgraded.