I'm importing a excel file in to my database but once the file imports, it drops off the leading zero off of the account number. I have figured out my data types and I'm using (DT_NUMERIC) on that particular field. Is there a way to keep that leading zero? Shanon

I will try importing data to a string type instead of a numeric type.

Hi, Yep - just like Jia Li said - try importing it as a string instead on a numeric field. In the Dataflow Task, right click on your Excel Source Adapter and select Advanced Editor. On the Input and Output Properties tab, you can select the problem column and change its data type to a string. Hope this helps, Brian

Hi I have the same issue however I need to also do a Lookup on the value that has the lead 0. Does this work if I change the field type to a String? Do I need to do this on both fields? Regards Scott

Hi I have the same issue however I need to also do a Lookup on the value that has the lead 0. Does this work if I change the field type to a String? Do I need to do this on both fields? Regards Scott