I have a global variable in a DTS package that I need to concatenate with another value that is in a SQL select statement. Any idea how I can do this in a SQL task or Active X Script??

Ex:

Global Variable is gvPtJournalID

select id + dept + 0 + (add global variable) from tablename
where id = X

I need to pass in the GV into the statement then do the select

yes you can do it see example below

' 205 (Change SourceSQLStatement)
Option Explicit

Function Main()
    Dim oPkg, oDataPump, sSQLStatement

    ' Build new SQL Statement
    sSQLStatement = "SELECT * FROM dbo.employee WHERE hire_date > '" & _
        DTSGlobalVariables("HireDate").Value & "'"

    ' Get reference to the DataPump Task
    Set oPkg = DTSGlobalVariables.Parent
    Set oDataPump = oPkg.Tasks("DTSTask_DTSDataPumpTask_1").CustomTask

    ' Assign SQL Statement to Source of DataPump
    oDataPump.SourceSQLStatement = sSQLStatement

    ' Clean Up
    Set oDataPump = Nothing
    Set oPkg = Nothing

    Main = DTSTaskExecResult_Success
End Function