This is regarding this example where Darren uses pkware to move a file.

http://www.sqldts.com/?246

Does this mean that pkzip needs to be installed on the machine ? could the
move command be used instead if that's not the case - what needs to be
initialized if so in the loop around code (instead of Filesystemobject - or
is it stille filesystemobject ?).

If i want to rename a fil can pkware be used to do this or should I use the
rename command ? (Want to add a date) - I have the following sentence which
can take the global parameter file name and give it a new name including the
date - below I hardcoded the filename to illustrate:

msgbox (left("c:\temp\excel.xls",len("c:\temp\excel.xls") -4)&"
"&date&".xls")

--Michael V.

Is this article _I_ do not use PKware to move the file rather I move the
File using the FSO and then I zip although I could zip and move at the same
time if I wanted. Have a look at the docs for PKWare but I would keep it
simple and use the FSO to do the stuff to which you refer.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote

Aha - but the comments said PKWare - didn't look like a pkware command
however...

Where can I find FSO documentation - in cmd (DOS) i know rename, move - but
where do I find the fso commands ?

Thanks Allan


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> skrev i en meddelelse
news:evpeM2IhEHA.3236 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

I have a little "Pocketbook" about Scripting but try here first

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

http://msdn.microsoft.com/library/de...ist/webdev.asp

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote