Passing a variable to a DTS Package from SPROC

Hello all,

I am trying to pass a variable from a stored procedure into a dts package. In the dtsrun command (within the stored procedure), I have added the following:

/A batchID:varchar(50)=@messageBatchKey

In the package I added batchID into the global variables tab and set it as a sting. What I need to do is perform a data transfer based on the batchid that I pass in.

Here is what I am doing in the Transform Data Task query section:

SELECT t_sqlbox_outbox_sms.*
FROM t_sqlbox_outbox_sms
WHERE t_sqlbox_outbox_sms.message_log_id = '" & _DTSGlobalVariables("@batchID").Value & "'

Nothing seems to be working though. Can someone help??

Thanks!!!