Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Nitu
Yak Posting Veteran
81 Posts |
 Posted - 2006-03-17 : 11:56:52
|
| Hi,Is there a way to do the following in DTS.There a zip file in a FTP site, which contains a mdb file. I need to download it first and then extract the mdb file from the ftp site and tranfer the data in to a table in sql server.I can do the last part, tranfering data from mdb to sql server table, but its the first part that i need help with.Hope sombody can help me out with this.(Note: I have very very little knowledge on dts).Thanks a lot in advance,Nitu |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-17 : 12:40:54
|
| U may use the following wayFTP from some other location using DTSUsing the following link, find the way to run a dos command (in command line) to Unzip the file and extract to a specified locationhttp://www.winzip.com/prodpagecl.htmif the result is successfull, proceed with transfering data from mdb to sql server |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Is there a way to do this...