Thanks for your reply. Do you know any tutorial or Form about this issue? i google it but no luck.

No problem,

Source ==> OLE Db DEStination (Access)

Transformation ==> If Needed

Destination ==> SQL

One field in Access Source called "Description" Here is Table Structure as an example

ID ...

Thanks for your reply, Here is the situation, I have Access Source and Sql Destination, I am using SSIS, One of the source file has link, Once you hit that...

Here is the syntax in case some one need it,

Update HG2

set id = hg1.id

from hg2

inner join hg1

on hg2.addr = HG1.ADDR = SUBSTRING(ADDR,1,(LEN(HG2.ADDR) - LEN(LTRIM(RTRIM(REVERSE(SUBSTRING(REVERSE(HG2.ADDR),1,charindex(REVERSE(HG2.ADDR),' ',1))))))))

Its good idea if your...

Guys thanks for reply, I know i can accomplish this one through SSIS without buy any tool, But here i am stuck because of tsql code, and i want to...

Thanks for reply, Here is my complete question

Here is my source

Table1

IDADDR

1 21345 NORWAL BLVD

Table2

IDADDR

721345 NORWAL

My question is I want to update my Table.ID...

Here is the problem, ID Column is not in sequence,

ID = H:1105181028581180

ID = H:1105181028581976

And so on……

I am using MM+D+HH+N+SS+AUTOINCREAMET# FOR MY ID COLUMN.

I appreciate your help, Here is the error that i am getting

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the varchar value 'H:1105181028588904' to data type int.

Note:-...

ID# VALUE ID

C-1234 NULL 1

M-3456 NULL 2

IF SOMETHING LIKE THIS THEN?

Here is the result that i am getting sir,

IDCOLUMN_ACOLUMN_Bnew column

1CA NULL CA

2NULL GA...

appreciate your prompt reply, after i run your suggest query i am getting result listed below,

IDCOLUMN_ACOLUMN_Bnew column

1CANULLCA

2NULLGANULL

3MANULLMA

New column i m using in derived column. They just copy Column_A value...

Thank you for your reply, It would be great if you can help me with expression i am not very good in expression.

Thanks for your prompt reply, I know my 95% data is good and 5% is bad, and i am sure i can use expressions to get what i want but...

First step to add column (COLUMNXY)

second use update statement

UPDATE STATE

SET COLUMNXY = (TYPE,'-',STATE)