Thanks guys,

Yes it is an oracle connection and I have installed the oracle client tools. Checked the sysadmin role and added DELL\twadmin. No change on the result however. I am...

Thank you Brian, here is the Step 1 detai:

Executed as user: DELL\twadmin. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnStart:  DTSStep_DTSDataPumpTask_1   DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error =...

The job failed.  The Job was invoked by User sa.  The last step to run was step 1 (dts_FWFMdynamic).

Thanks,

B

Thanks for your help everyone....

Yes I had QA set to 255...which was throwing me off the mark...cauing me to look at the procedure... but since I was exporting the data...

Perhaps to clarify:

I declare @myvar varchar(600)...then loop through a cursor building out a string of ids if criteria are met:

SET @myvar=@myvar+' '+@userid

So that I end up with a...