Hi,

I have task to automate for loading Excel files. In this excel file every
time i get with diffrent name as well within excel every time different
worksheet name.

Good thing is format is static but I need to find out way to rename to
common name for excel file and common name for worksheet. So i can import
data into SQL server using DTS.

Goal : rename excel file, rename worksheet.

Any idea ?

Thanks
Kris

Use Active script to rename you files. Here is an example for text file, use
the same idea for excel files.
http://www.sqldts.com/default.aspx?200
Rgds
JFB



"Kris" <Kris (AT) discussions (DOT) microsoft.com> wrote

You could use the execute process task to run the rename.exe and pass
parameters. You could programmatically set global variables to
concactenate together the command line parameters and then use a
dynamic properties task to set that in the execution process task
before it runs, that is if your renaming is going to be dynamic in some
way.

Thanks for reply.

Renaming Excel file name is no big deal, I am using FSO in Activex Script.
How ever still i don't know how to rename worksheet ...any help ..

Thanks
-Kris

"JFB" wrote:

Can you please provide information how you rename file in Excel from DTS? Do
you know how to remove all records from existing Excel file that new records
from data transformation service would not append to existing?
Thanks,
Ilin

--
Message posted via http://www.sqlmonster.com

its easy :

1) First to remove records ..I would prefer to drop excel file..
2) here is url ...

http://msdn.microsoft.com/library/de...bjectmodel.asp



"Ilin Star via SQLMonster.com" wrote: