Could it be that formatting has been applied in Excel to display the value to 2 decimal places?

Try exporting from Excel to CSV and then using Notepad to see what's...

aaron.reese (7/23/2013)

---

Phil, Thanks but no thanks 🙂

I hate regex. The regex would need to treat it as a string (either explicitly or cast in a derived column) and then...

If you're a fan of Regular Expressions, you could do a Regex match on it to reject anything other than

NNNN-NN-NN

where N is in the range [0-9].

Are you saying that...

That's more like it, thanks for taking the time to clarify Jason.

I understand that you were trying not to get too technical with your first answer & just wanted to...

Create a query which runs against your Oracle data.

The query should return the data in the format you want to insert to SQL Server.

Use the query within a data flow...

Can you write a query which executes against the Oracle database and brings back the data in the format you want?

If you can, job done - use that as your...

I have some questions about your post wolfkillj.

What do you mean by 'logically' in the above?

*However*, clustered...

Elliott - your workaround idea worked a treat, thanks again.

Elliott Whitlow (7/21/2013)

---

Phil,

I don't think you can prevent it once its been started. I think you have to do all the work to make sure that the values will...

Use Windows authentication in your connection.

No problem. Well done on getting it working.

J0shu@ (7/17/2013)

---

Yes the columns are the exact same, the only change is the file name and sheet name.

I want to also make sure that I'm configuring the data flow...

There is an example here that might be relevant to you.

Are the column names exactly the same in all of the files?

Is there exactly the same number of columns in all of the files?

Are the columns in exactly the same...