try this...DTS gets funny with return codes and setting output variables.

DECLARE @rc int

DECLARE @partition varchar(10)

DECLARE @nextid int

DECLARE @id int

set nocount on

-- Set parameter values

EXEC @rc = [TrafficAnalysis_Prod].[dbo].[usp_get_next_tblcdr_id]

@partition = 'aged', @nextid =@id OUTPUT

set nocount off

SELECT @id AS next_cdr_id