Charip,
First Logging would have to be enabled. Do you know if you have logging enabled?
Here is a whitepaper on the subject provided by our friends at Microsoft.
http://msdn.microsoft.com/en-us/library/ms138020.aspx
You could also run the package in debug mode and comb through the results and find the error that way.
This information is readily available via google searches or Technet searches.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events