Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  file name from variable

Author  Topic  feil Starting Member 3 Posts Posted - 2006-01-09 : 13:58:30 I do not know ActiveX.... I would like for form a dynamic file name in a SQL command that is a funcion of a global variable. ie. "datafile" + @yesterdaysdate Can this be done? If so could an example be provided. I have successfuly created the global variable and used it as a parameter.