Thanks all. It works

sorry for the confusion.

Please consider second example that I provided. I need acheive below:

If Cust_No contain NULLs, I need to update the NULL value with the value from the...

Sorry if my example in previous post was confusing, please find below more simplified data that needs replication. thanks

UrnCust_No

2200000

3NULL

4NULL

5NULL

6NULL

7NULL

82500000

9NULL

10NULL

11NULL

UrnCust_No

2200000

3200000

4200000

5200000

6200000

7200000

82500000

9200000

10200000

11200000

Thanks all. I have worked out the solution.

Thanks for the help. Further to that, how can I find out which server (SQL or Analysis) one is hosted my server. This may sound silly (any friendly DBA can...

Thanks guys. Much appreciated.

I am using SCRIPT Component. When I enter DTS MS Visual studio do not populate with the properties for dts. Do I need to import other than I have already...

Hi,

Here I am using Script component to export into multiple flat files. Once row reaches 10000 rows, I need to change connection string so that I can point to different...

Do you know of any code sample link or article related to this please? Thanks

Thanks a lot for your help. Much appreciated.

Thanks. Is there any code sample or any article which can help me develop this? Because I am new to .Net programming. Thanks

Thanks. I am relatively new here. Is ther a way is anyone send codes to do that or information secific to my problem? Thanks

Thanks for the update. If this is going to create security worries, is it possible import inbox saved as a file. We are planning to do some analysis on email...