Hi ,

I am using SQL Server 2005 Enterprise edition SP4 (64 BIT) ON Windows Server 2008 R2 Standard edition 64 bit SP1 .

Below mentioned is the structure of the two tables.

USE [Nice]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Table_Test1](

[emp_code] [varchar](10) NULL,

[first_name] [varchar](30) NULL,

[last_name] [varchar](30) NULL,

[middle_name] [varchar](30) NULL,

[initials] [varchar](10) NULL,

[pay_code] [varchar](10) NULL,

[pay_rate] [varchar](10) NULL,

[paid_by] [varchar](10) NULL,

[birth_date] [varchar](20) NULL,

[gender] [varchar](10) NULL,

[ssn] [varchar](10) NULL,

[street_addr1] [varchar](40) NULL,

[street_addr2] [varchar](40) NULL,

[city] [varchar](40) NULL,

[state] [varchar](40) NULL,

[zip] [varchar](40) NULL,

[phone1] [varchar](20) NULL,

[phone2] [varchar](20) NULL,

[hire_date] [varchar](20) NULL,

[sen_date] [varchar](20) NULL,

[dept_date] [varchar](20) NULL,

[term_date] [varchar](20) NULL,

[status] [varchar](10) NULL,

[wrk_status] [varchar](10) NULL,

[hrs_week] [varchar](40) NULL,

[homedept_id] [varchar](10) NULL,

[Test_Code] [varchar](40) NULL,

[user_name] [varchar](30) NULL,

[Testing_Code2_1] [varchar](32) NULL,

[Testing_Code2_2] [varchar](32) NULL,

[Testing_Code2_3] [varchar](40) NULL,

[Testing_Code2_4] [varchar](32) NULL,

[Testing_Code2_5] [varchar](32) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

USE [Nice]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Table_Test](

[col1] [varchar](40) NULL,

[col2] [varchar](40) NULL,

[col3] [varchar](40) NULL,

[col4] [varchar](40) NULL,

[col5] [varchar](40) NULL,

[col6] [varchar](40) NULL,

[col7] [varchar](40) NULL,

[col8] [varchar](40) NULL,

[col9] [varchar](40) NULL,

[col10] [varchar](40) NULL,

[col11] [varchar](40) NULL,

[col12] [varchar](40) NULL,

[col13] [varchar](40) NULL,

[col14] [varchar](40) NULL,

[col15] [varchar](40) NULL,

[col16] [varchar](40) NULL,

[col17] [varchar](40) NULL,

[col18] [varchar](40) NULL,

[col19] [varchar](40) NULL,

[col20] [varchar](40) NULL,

[col21] [varchar](40) NULL,

[col22] [varchar](40) NULL,

[col23] [varchar](40) NULL,

[col24] [varchar](120) NULL,

[col25] [varchar](40) NULL,

[col26] [varchar](40) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

The tables which I am using doesn't have an int data type. I am not using SSIS. If i use SSIS i can skip each column like you had said.

If i found the int data type i could have fixed the issue myself. I suspect the code. That's why I had asked your help.

When i notified to the user he went and deleted the data which has the values 2314K. After that the Job is running successfully . I am looking in the code perspective what had caused the issue. If the user enters bad data this issue can happen again.

Thank You,