You can use some of the extended stored procedures such

sp_OACreate to create the DTS package, run methods with sp_OAMethod and then dynamically set global variables with sp_OASetProperty 

This has been successful for me...