wolfkillj (7/25/2013)

---

A data source has to be able to access the metadata to expose its output columns. I haven't verified this, but I don't think the metadata of a data...

peterzeke (7/26/2013)

---

Thanks for such a quick reply, Phil.

As you suggested, I exported a spreadsheet as a text file. The values in the text file match the values in the...

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...