Can an SQL DTS package ftp (get) a password protected zip file, extracts the contents (Access 2000 database file) to a predetermined location so that the contents can be imported into SQL? If so, I could use some help.
SQL Server is SQL Server is Microsoft SQL Server 2000
(reworded from above for clarification)
The situation: We are trying to automate the following process.
1) FTP (get) a zip file (Less than 5mb in size)
2) Extract the contents of the zip file (file is password protected). <em>The file within the zip file is an access 2000 database file with about 15 tables.</em>
3) Import these 15 tables into our SQL Server.
I need help with Step 2. We already have a DTS package to handle step 1 and Step 3.