Hi except one case everything is working fine.if numbers avilable in state column then we need numbers also in the output.

example: State column have value : abc123&~ then...

we need replace bad character with empty string and expected output like below.

id | Name

1 |testtedabc

2 |anra

3 |gsreCedab

4 |MfeDF

5 |Rtemd

6 |jadji

7 |Cjeyretn

8 |Jkbalu

9 |eneiokd

10 |iodePyrnie

11 |VsGta

12 |SoPaulo

13 |vAstragAtaand

14 |ubleBioBio

15 |UpndsVAsby

Please...

hi 64-bit ODBC client for MySQL driver not support in ssis 2012 (BIDS)version .i tried one more way in

using the MyODBC driver, the configuration UI has an advanced...

executing package with 32 bit.

when i used

{if Char.IsNumber(Row.ID)

{

Row.isvalid= true;

}

else

{

...

1)In Source side having Only one column i choosen for test purpose and that field name is name;

2)after that i used script component and select name field and oupput columns

...

without chang datatype we need to do this one.

Hi all, applogy to given some wrong information. Here Cube Name :Testcube....> its having measures expected,payment.

dimensions: dimpatient: its having attribute is pn

...

based on group wise we need display new row(adjust) . all information in one table only.

here billamount-sum(paymentamount) and then get adjust new row records based...

Thanks.its working.

its not given exacetely results and doj format data 0 not added .

2/23/211 change...

Hi i think here we donot need update statement we need add prefix zero for each mm/dd/yyyy format

doj (data type is varchar(30))having data like change

...

hi thanks to given valuble information.please can you clarify few things.amazon provideing database services like amazon rds,amazon redshift.

amazon rds means its provideing databases like sql server,oracle,mysql.

amazon redshift its relateds...