Thanks and you are the Best

Sorry, I didn't read your msg. I did mess the question here.

as you are aware, the following are the input data.

tblA contains

CustomerKey bigint

CustomerID varchar(25)

CustomerKey CustomerID

98878787 ...

Hi, thanks for your help.

I did convert the same but gettign the following error.

Error Converting data type nvarchar to bigint

Again, it's a typing error.

I don't agree that English is a predominant. Oflate, I don't prefer to speak in English except whenever I am in another country. I want my...

Nobody is disrecting anybody here. You live in China or US or India wherever you want to. Even, I live in the US too. English is not my first language....

Please do not take me wrong. Again, I am not against to any language. But, people think that English is the universal language and it is superior whereas other languages...

English language is similar to other languages. But, one must understand that the English language is the combination of words from other languages though the primary base for it is...

Thanks Matt.

It worked.

Best Regards,

Ram

Ramesh!

Your answer is excellent!

Hats off!!!

Ram

Hello All,

First of all, thanks for your help.

The value 1177091222608 is an integer datatype in a table that represents the original value of a date '5/11/2007'. For the purpose...

Crispin,

First of all, thanks for your response. Can you please give me a step-by-step approach how to setup and modify the config files? This ssis is driving me crazy.

None responded in this forum...

To change the actual contents of the string, suppose, we can use

System.Text.StringBuilder.

Other members can chip in.....

Ram

I am really sorry to hear this. But, please make sure that you do your best as long as you are at work. NEVER EVER trust HR and they protect...

Thanks for your time and it worked... Appreciate it..

-- R

Thanks for your mail.

I am gettign this data from a remote location where the users might have made the data entry incorrectly. But, still I have to validate this...