|
Home > Archive > MS SQL Server DTS > January 2006 > Help with DTS packages!!!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help with DTS packages!!!
|
|
|
| Hi
Using DTS Packages:
I have to downlaod a file from ftp server which is not a problem, but this
file is a zip file which consists of a mdb file.
Now, is there a way to extract the mdb file from this zip file from the dts
package.
If there is, can you please give me some sample on how to do it, i would like
to remind u that i am a newbie,
Thanks a lot in advance
--Nitu
| |
| Allan Mitchell 2006-01-26, 4:58 pm |
| Hello Nitu,
There is nothing built in to DTS to do this. If you own a Zip tool and it
has a cmd line version you can call that from within the Execute Process
Task.
Allan
> Hi
> Using DTS Packages:
> I have to downlaod a file from ftp server which is not a problem, but
> this
> file is a zip file which consists of a mdb file.
> Now, is there a way to extract the mdb file from this zip file from
> the dts
> package.
> If there is, can you please give me some sample on how to do it, i
> would like
> to remind u that i am a newbie,
> Thanks a lot in advance
> --Nitu
|
|
|
|
|