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:54:54
|
| 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 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-18 : 23:27:00
|
| if you're going to do this all via sql, check nigel's sitehttp://www.mindsdoor.net/#FTP--------------------keeping it simple... |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2006-03-22 : 11:26:51
|
| It's all possible, as long as the mdb file remains on the same structure every time you download it from the FTP site.This is the way I would attack on my DST:1) ActiveX to download the file2) ActiveX to unzip the file to a specific location3) Step to delete data from the SQL tables4) Load SQL tables with records from the .mdb tables5) Delete all files used on the process---Thanks!Igor. |
|
|
|
|
|
|
Is there a way to do this...