http://blogs.msdn.com/b/repltalk/archive/2010/04/05/how-sql-server-2005-2008-replication-resumes-interrupted-snapshot-delivery.aspx

The need may arise when you need to restart the entire snapshot processes. You can execute the procedure sp_resetsnapshotdeliveryprogress on subscriber database to reset snapshot delivery process...

It's because your source table's data type/format are out of the range of destination tables.

Usually it's "Date" type.

@Peandaddy