SSIS Help

[kum5758]

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.

 

 

[agora]

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cc1c8285-76ed-48bd-b77a-9f67af7e51e2/leading-zeros-in-csv-file?forum=sqlintegrationservices

[Srimantudu]

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

[kum5758]

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.

 

[Srimantudu]

2 minutes ago, kum5758 said:

tried that bhai, not working.

 

https://www.sqlservercentral.com/Forums/Topic674975-148-1.aspx

 

try derived column

[Srimantudu]

http://stackoverflow.com/questions/2868348/how-do-i-get-ssis-data-flow-to-put-0-00-in-a-flat-file

[gade_swarup]

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

[kum5758]

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