I'm not having much luck getting info on this one. Has anyone passed parameters to a DTS package? Is it possible? I setup a DTS package to import an xls but the file name & location has to be variable. I've been experimenting with DTSGlobalVariables but haven't been able to write to them from my stored procedure that starts the DTS package. Am I barking up the wrong tree?