Just out of curiosity... have you tried to log into your SQL instance with the ColdFusionUser from QA?  I'd be curious to see if you can even get that far.

Now that I've re-read your question I'd suggest not using a data driven task anyhow. 

you should be able to acomplish your objective with joins...

First Copy your data from the...

This will only work as long as all of your values end with .00.

Create TABLE #tmp(

col1 varchar(10) NOT null

)

INSERT INTO #tmp (COL1) vALUES(1000.00)

INSERT INTO #tmp (COL1) vALUES(500.00)

INSERT INTO #tmp (COL1)...

Bob, Chuck is correct you want to do this as a set based operation not as a Loop. 

As a CF dev, I know you're used to looping over another...

If everythign was workign fine before you applied the Policies I'd imagine that you changed from Mixed-mode to Windows Authentication only, or perhaps the other way around, or you are...

You could perhaps use an updatable veiw?

Or 3 different tasks.  One for each table I'd imagine this could be done with a Data Driven Query.   

If you will only be dealing with Whole numbers and all of the numbers would be like your example.  You'd just need to drop the .00. This can be done...

Thanks, Greg and Shawn.  Greg, I kind of figured as much, but I wasn't able to come up with anything that actually stated that.  Thanks a bunch. 

I suppose I'll...

The way I've done success/fail logging before is instead of creating different packages,  do this in one package with different tasks.  Setup your workflow properties to keep the package from...

Thanks for your reply.

The text file resides on a network share not on the same server as the SQL server which my user account has admin rights to both on...

Yeah my one for the 8th I received late on the 8th 1815 EDT, so to me it looked like I recevied it the 9th because I didn't check that...

Have a look at this... It may help.

http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.programming/2004-04/4701.html

-Luke.

Since you are transferring more than 1 million records, why not use BCP?  It'll be much faster than DTS, and you can break up the batches into smaller segments and...

How are you creating your success/fail/general logs? 

Are they being written by workflow tasks inside your package? 

Are they being written to from the Step/Advanced Tab of a SQL Agent...

also if you receive files withthe same filename everyday you could use a linked server va the Jet 4.0 text driver.  It's somewhat slow for large files, but it should...