I know the active X script doesn't really show much...the post would have been longer and more confusing if I would have posted the code for each look up. 

The...

Here is the function I came up with that would do the logic I need...

DECLARE @location  VARCHAR(3),

 @LocID  VARCHAR(5),

 @LocType VARCHAR(3)

SET  @LocID   = '91A'

SET @LocType  = 'HR'

 SELECT  @location = PlantCode

 FROM    DBA.dbo.tb_ci_Plants

 WHERE   PlantCode = @LocID

 --If the...

You are my hero Greg...that was it.  When I checked the version of QA, it

I ran the SP4 upgrade, rebooted and attempted the same task...works...

If I go on the server and login with the service account...I can get into the DTS no problem.  However when I attempt to open a tansformation data task from...

Very interesting...I will try to log into the server and open the data task there and see if there is any difference...

I was going to try to log into the...

Hi Sergiy,

I am not 100% following your comment that you don't believe it could take 30 seconds...but I will try my best at the reply.  The SP goes through a...

This is on a test server I am running the sp on, so I am the only one on it.  And the process is the only thing running.  So I...

The execution is the same, I have NOCOUNT ON, and the time doesn't matter when I run it (job schedule) always seems to be slow. 

I don't know about the...

I am not insisting on using them like they are my favorite thing in the world...I inherited the code from the previous person who wrote something similar and I would...

I haven't had too much extra time at the moment to work on this process further.....

Sreejith I looked at the last post of yours, and the example you left for...

Looks good...I think this might work.  I am going to have to test it out on some senerios and see what it turns up !!

Thanks again for the logic

Lee

YES ...that is it...in a nutshell.

This process is supposed to pull out the information from a master table...filter it down....get the most recent record based on the revision number and the status (A,D,H,I) in that...

HI Jeff,

I shouldn't have used the term Dataset...that probably was confusing.  I have this process working with the cursor...but I am always open to different and better ways to optimize...

Unless someone can recommend a different way to do this I think I need to use a cursor.  I will break it down as simple as I can.

I have TABLE...