Changing excel spreadsheet names using DTS

• brian clements-470670

  Mr or Mrs. 500

  Points: 511

  More actions

  June 19, 2008 at 11:44 am

  #187377

  Hello,

  I'm new to SQL Server DTS. My delimma is, I'm trying to create a package that will run monthly

  while building an excel spreadsheet. The results will come from one query, however the excel

  spreadsheet name must be changed. How do I change the name of the spreadsheet in the package?

  Thanks in advance.

• brian clements-470670

  Mr or Mrs. 500

  Points: 511

  More actions

  June 20, 2008 at 6:06 am

  #831683

  Problem solved I decided to build an activex script that will move the excel

  file to its directory while changing the name every month.