Looks to me like you're almost there, although you have a few problems.

First, the "ExecuteReader" call isn't necessary. Your stored proc is not returning a result set, you're using an...

Not sure what you're asking exactly, but it looks like the package is deleting from some source and then reloading that source from data in an Access database.

The "Delete from...

Well as a developer I have my issues with that. Because you will probably want to log to local disk. And thats where a developer has usually no access to....

Not sure what you mean by "lose your package layout"...I don't think I've lost any layout in the packages I've migrated to structured sotrage files and I'm using embedded packages...

Why don't folks use structured storage files more, rather than storing packages in SQL Server? Putting packages in structured storage files makes moving packages around much easier (just a simple...

Yes, and there's still an ActiveX control too, which I don't allow to run. What is that for exactly? Doesn't appear to be critical for navigation as I can get...

Oracle Client needs to be there, but you also need to make sure your SQL*Net configuration is correct and that you've got an entry in your TNSNAMES file.

Not sure if...

Another argument for stored procs is from the perspective of deployment of the application. Depending on the type of application (e.g. a desktop application deployed to many clients), use of stored...

Might also help to share why you need to store this data as XML, or maybe what you are wanting to accomplish, as that might help everyone to help you...

Your XML data contains binary characters that are illegal in XML. As such, you don't have much choice but to do something with them. If you cannot just outright strip...

Try storing the value "12.5" in a DECIMAL(3, 1) field.

I already said that I understand perfectly well that there are some numeric values that cannot be stored precisley in SQL...

Yeah, sorry for the multiple posts, not sure why that happened. Anyway, I'm still not clear on what you're talking about.

Is it perhaps that you're playing a semantic game whereby you...

Yeah, OK, whatever. Would you please, as I originally asked, elaborate on the apparent contradiction between your statement:

No datatype decribed as holding absolute precise numbers. Because it would be...

Yeah, OK, whatever. Would you please, as I originally asked, elaborate on the apparent contradiction between your statement:

No datatype decribed as holding absolute precise numbers. Because it would be...

Yeah, OK, whatever. Would you please, as I originally asked, elaborate on the apparent contradiction between your statement:

No datatype decribed as holding absolute precise numbers. Because it would be...