You can use SQL Data Compare from Redgate. As you can download trail version from the site for 14 days it will suite for you

it seems that you can string values in that specifc column. To verify this can you import those data to varchar field and verify.

It may be that you have...

Your report is trying to access the data source named 'Dynamic_Connection' which is not existing or invalid.

1. Go to report properties and assign correct dataq source

or else

2. create a correct...

I have the same issue.

But there are suggestion from Mircosoft, to set Partial or None to Cache property of the lookups.

But this didn't work for me. Buit worthwile trying.

http://www.mydatabasesupport.com/forums/sqlserver-server/189104-sql-agent-issue-winzip.html suggets you to do this with winzip command-line add-on

The problem appears to be that whatever address or alias was used to create the OLE DB connection can't be resolved from where the package is executing. Maybe it was...

Verify whether your sql server agent user has enough permission to C:\Folder

What are the parameters you passed to unzip your text files

http://www.sqlserverdatamining.com/ssdm/Default.aspx

In the flat fiel connection manager, select tick box for Column names in the first data row option

checkthis

http://204.9.76.233/articles/dba/import_text_files_ssis_p1.aspx

http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx

You can have Package configuration

Make sure that you enable it by using a T-SQL task after the execution of your task

in SQL Server 2005 there are few methods for data validation and data cleansing

http://204.9.76.233/articles/dba/data_cleaning_ssis_p1.aspx