In fact - the x64 version of DTExec is not installed when you install SSMS.  It is only installed when you install Integration Services - and then will only...

You can install the opposite driver using the command line and specifying either the /quiet or /passive arguments, regardless of which version of Office has been installed.

Great tip! I never...

I checked the link, but I still think that I am right. That's just the sort of guy I am 🙂

Packages do not have bitness.

My educated guess is that those...

Rather than attempting to answer all of your questions, I'll bite off a chunk.

To get both 32- and 64-bit version of the ACE driver (which is used to import .xlsx...

Aha, that makes a lot more sense! But of course the default table round here comes loaded with DDL, data and constraints 🙂

If you are hoping that someone will write some code as a result of seeing this table, you are better off providing the DDL and DML to create and populate...

I know very little about Oracle, but I'm assuming that it has some sort of trace facility which would allow you to capture the actual UPDATE statements which are being...

Can you Preview the file, or does the error happen before that?

Have you worked out exactly at what point the decimal values 'go missing'? Can you take SSIS out of the picture and replicate it purely in Oracle?

Do you care about...

It's been so long since I've had to deal with 2005 that I cannot remember any of its idiosyncrasies, so I don't think I can assist further with this one.

You...

OK. You...

There are pros and cons for either option.

If you're storing the files primarily for archival purposes, I would not put them into a database ... why bother?

If you have other...

"If I change the destination of the package to another instance..."

Is that another 2005 instance?

Is there anything going on in the data flow, or is this a straight source -->...

Are you running this in Debug mode in Visual Studio?

Here is some sample code to get you started.

DROP TABLE IF EXISTS #AviationWeather;

CREATE TABLE #AviationWeather
(
    XMLDoc XML NOT NULL
);

INSERT #AviationWeather
(
    XMLDoc
)
VALUES
('<response...