In a Data Transformation Services (DTS) package in SQL Server I have a "Transform Data Task". <BR>In the source query of this task I want to select some data from a table as well as the value of a global variable of the DTS package. I would like to know how to do that.<BR><BR>As far as I know I should place a questionmark (?) and then map that parameter to a global variable, but that will only result in a syntax error.<BR><BR>I have tried queries such as these:<BR>SELECT myColumn, ? AS myParameter FROM myTable<BR>SELECT myColumn, myParameter = ? FROM myTable<BR><BR>Does anyone know how to do this?