kum5758 Posted May 9, 2017 Report Share Posted May 9, 2017 Hi All, need small help. Last 4 digits phone number exists in table, need to export to .CSV file. But if last 4 digits are having values like 0987, 0997,0978,0657 .CSV file is ignoring leading zeros. is there any way we can retain leading zeros in .CSV file.? Thanks. Quote Link to comment Share on other sites More sharing options...
agora Posted May 9, 2017 Report Share Posted May 9, 2017 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cc1c8285-76ed-48bd-b77a-9f67af7e51e2/leading-zeros-in-csv-file?forum=sqlintegrationservices Quote Link to comment Share on other sites More sharing options...
Srimantudu Posted May 9, 2017 Report Share Posted May 9, 2017 19 minutes ago, agora said: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cc1c8285-76ed-48bd-b77a-9f67af7e51e2/leading-zeros-in-csv-file?forum=sqlintegrationservices keep it up Quote Link to comment Share on other sites More sharing options...
kum5758 Posted May 9, 2017 Author Report Share Posted May 9, 2017 34 minutes ago, agora said: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cc1c8285-76ed-48bd-b77a-9f67af7e51e2/leading-zeros-in-csv-file?forum=sqlintegrationservices tried that bhai, not working. Quote Link to comment Share on other sites More sharing options...
Srimantudu Posted May 9, 2017 Report Share Posted May 9, 2017 2 minutes ago, kum5758 said: tried that bhai, not working. https://www.sqlservercentral.com/Forums/Topic674975-148-1.aspx try derived column Quote Link to comment Share on other sites More sharing options...
Srimantudu Posted May 9, 2017 Report Share Posted May 9, 2017 http://stackoverflow.com/questions/2868348/how-do-i-get-ssis-data-flow-to-put-0-00-in-a-flat-file Quote Link to comment Share on other sites More sharing options...
gade_swarup Posted May 9, 2017 Report Share Posted May 9, 2017 1 hour ago, kum5758 said: Hi All, need small help. Last 4 digits phone number exists in table, need to export to .CSV file. But if last 4 digits are having values like 0987, 0997,0978,0657 .CSV file is ignoring leading zeros. is there any way we can retain leading zeros in .CSV file.? Thanks. Open Csv in Notepad or notepad++ ,if you open csv in excel it will trim leading zeros Quote Link to comment Share on other sites More sharing options...
kum5758 Posted May 9, 2017 Author Report Share Posted May 9, 2017 1 hour ago, gade_swarup said: Open Csv in Notepad or notepad++ ,if you open csv in excel it will trim leading zeros correct bhayya. informed to user. chudali Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.