Here is my requirement.

I need to copy the zip file from one domain to another using DTS package.
The zip file has a .bak file which then needs to be restored.
If anyone has any pointers, please let me know

Thanks
GS

You will need to open the file (unzip) and you can do this using the
cmdline version of your favourite zip tool and the ExecuteProcess task.
After that it is a simple case of issuing a RESTORE command afterwards.

Alla

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

Thanks much for the input. i think i was not clear on m requirement. my bad.

I need to copy the file from one domain to another, unzip the file and
retsore the file as a database using a DTS package. Is there a peroperty by
which I can unzip the file in DTS package

Thanks
GS

"GS" wrote:

Hello GS,

Out of the box no. Like I mentioned you will either have to write yourself
a custom task to do this or you can call your favourite zipping software's
cmdline version and do it there. Most will allow you to say from where and
to where this unzipping should occur.

Have a look here.

How to manipulate the Execute Process task.
(http://www.sqldts.com/default.aspx?251)

Allan