gundugadu Posted January 10, 2013 Report Posted January 10, 2013 [quote name='Desamudhuru' timestamp='1357853748' post='1303087286'] so text qualifier two " petala ?? "" [/quote]okate baaaaaaaaaaaaa "
loveindia Posted January 10, 2013 Report Posted January 10, 2013 Ok here is what I found.. CSV lo it will strip that 0 no matter what since formatting is not an option there.. But if you open the same file as notepad you will see the 0's you are doing. so when you upload that data to other systems u will see that 0's again..
Desamudhuru Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='loveindia' timestamp='1357849428' post='1303086518'] flat file connection properties ki velli, in the advanced tab set it to DT_STR. instead of Derived column. It will do the work I believe. or use this....... REPLICATE("0",3 - LEN([columnname])) + [columnname] Try and tell me.. [/quote] rendu chesina mama avadam ledu
Desamudhuru Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='loveindia' timestamp='1357854649' post='1303087442'] Ok here is what I found.. CSV lo it will strip that 0 no matter what since formatting is not an option there.. But if you open the same file as notepad you will see the 0's you are doing. so when you upload that data to other systems u will see that 0's again.. [/quote] Yeah first ok 2000 rows upload chesi chusani. On Salesforce.com they can see only 39 not 039. Y i need leading 0 is.... 039 anedi oka link laga avuthundi in salesforce.com
loveindia Posted January 11, 2013 Report Posted January 11, 2013 [quote name='Desamudhuru' timestamp='1357857225' post='1303087790'] Yeah first ok 2000 rows upload chesi chusani. On Salesforce.com they can see only 39 not 039. Y i need leading 0 is.... 039 anedi oka link laga avuthundi in salesforce.com [/quote] Upload to Salesforece.com ela chestunnav re.. Is it using SSIS again or any other?
Recommended Posts