Regarding "No datatype described as holding absolute precise numbers...", this quote from Books Online seems to contradict you:

Using decimal, float, and real Data

The decimal data type can store...

Even if you use stored procedures, you are still embedding SQL (stored procedure calls) into your application.

One thing I've found is that it's important to not have SQL scattered all over...

What version of Informatica are you using?

Do your session and/or workflow logs for the workflow and session(s) having the problem report any errors? You said there's something about missing records,...

I've encountered problems when trying to set variables of a package that I'm executing, wonder if you're having the same problem? There is a problem in DTS that surfaces when dealing with...

Matt, "@@Scope_Identity" is not valid, try:

SELECT scope_identity()

instead. Like @@IDENTITY, it returns NULL on a new connection (or at least it does for me).

OK, now I'm a bit confused...are you still just trying to execute a package you created (executing it from your code)? Sounds like you're trying to create the package from scratch...

Is there any reason you need all those extra objects? Are you simply trying to export the data from the one column to a text file? To do that, all...

Had this happen too. It's apparently a bug in DTS. You have to remove all the variables and then re-add them with their values.

For example, create a NameValue collection that has...

That is most certainly possible, I've got some apps that do this very thing. You can find a lot of resources on how to do it, here's a couple (Google for...

Not exactly sure what you are asking. Are you asking how to create a DTS package using .NET? If so, I wouldn't do that, would be better to create the...

Hmmm. Looks like you've got a bug in your code...

 Set fso = CreateObject("Scripting.FileSystemObject")

 Set fold = fso.GetFolder(folderPath) 

 serverPath = "http://pe-ocr.apa.org/fulltext/psq_html_conversion/?"

 folderPath = "conversionPath=psq\Journals_proofing\SGML_to_be_converted\"

Should probably be...

 Set fso = CreateObject("Scripting.FileSystemObject") 

 serverPath = "http://pe-ocr.apa.org/fulltext/psq_html_conversion/?"

 folderPath...

The way I understand it, connection pooling is more about performance than reducing the number of connections needed. Making a brand-new connection to the server is expensive/time consuming (relatively), connection...

OK, so is it the service that executes/needs to execute the command?

If so, then if your service uses a domain account and that domain account uses a "trusted" connection to the...

Take a look at this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemSecurityPrincipalWindowsIdentityClassImpersonateTopic.asp

Describes how tom impersonate another account, programmatically.

Have you profiled the application? You said it's ADO.NET, are you certain that it's the execution of the query that's the problem or is it something else? For example, is...