Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
csphard
Posting Yak Master
113 Posts |
 Posted - 2006-10-31 : 11:16:33
|
| I am trying to upload some information to a table using dts.dts is uploading the information but dropping leading zeros.my information is a text file and its in the following formatemployee_number email_address000121,my@aol.comIt will load121 my@aol.comshould my information be in this formate"000121","my@aol.com"what do I do to stop it from dropping those leading zeros |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-31 : 13:50:01
|
| It should be ok. Just make sure DTS imports the column as varchar, not integer.If not successful, add " as you suggested.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
dts dropping leading zeros