Thank you very much!! That gave me what I wanted, although now it made me rethink this whole process and is giving me more work to do. lol Regardless, it...

your first line:

select j.Name , (case when k.Job_ID ISnull then 'Temporary' else 'Permanent' end )as 'Job_Status' from

should have a space between is and null:

case when k.job_ID IS NULL then...

yes, it would but I don't need the AutoID in the results just the type. There are times when I need to send AutoID 55 in as a type 2...

In the OLD DB Source Editor in SSIS the SQL command text looks like this:

SELECT

' ' AS WTIPOST

,Transfer_Num

,? AS WTTYP

,FrStore

,ToStore

,ItemNum

,Qty

,' ' AS WTINEG

,'00000000' AS WTIDATE

FROM ...

The problem is that it may be a 2, 4 or 6. I currently have 3 separate SSIS packages to handle each of the different types and I am trying...