Yes you are right that's y i am here!

I have 60 thousand records in my table, Should i use same solution?

Thank you all of you guys, Is there any way i can get free version?

I am in situation where i have complete address, but its really bad data and i...

Appreciate for your help!

Gila Thanks for your reply, Please tell me what do you men by "Codepage" i didn't get that part.

I tried all tips that i know, use derived column/advance editor/ and so on, My source has text data type field (I can't change it) and i have to map...

Thanks for your reply, How i can do one to one match and update in sql syntax ? Could you please post sql syntax for me?

Thanks for your reply, I know i can use "execute sql task " in ssis to use this procedure, just wondering is there any way i can fix this kinda...

Phil it is more than 60k rows my first thought was blank value giving me problem, but after you guys suggest find out which fields don't accept blank value i...

I create one test table with different data type i.e varchar,nvarchar,int,float,date,money and try to load with blank,0, values they run fine. I am assuming the problem is source table field...

i have 134 columns and its very hard to find out + time consuming to check each columns/data, May b i m wrong just wondering is it possible any data...

I just tried to Bulk Insert Task" and i m getting below error.

Progress: Preparing the following SQL statement: BULK INSERT]]

[Yolo_Source].[dbo].[test] FROM 'C:\_GIS.txt' WITH(CHECK_CONSTRAINTS,CODEPAGE='RAW',DATAFILETYPE='char',FIELERMINATOR='\t',ROWTERMINATOR='') - 100 percent complete

Thank you, I was not clear):,

Sorry for late reply, Thanks all of you guys your help. I can't change my target table.

I really appreciate if some 1 send me " Expression", Thanks.

Thanks for prompt reply!

The problem is they just provide Two db one is .mdf and other one is ACCESS db.

and there is no PK/FK/SP/VIEW. Any clue?

Let me re post my reply with correction and let me know if u still want me to copy structure table and data?

Create Table A (

ID Varchar(15),

ADDR VARCHAR(20),

STREETNOVARCHAR(25)

)

Create Table...