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 |
|
jjw
Starting Member
9 Posts |
 Posted - 2004-03-18 : 11:44:47
|
| Hello, New to the board but love the ideas given out. I've got a (hopefully small) problem. I need to import 2 text files from an ftp site to a SQL Server 2000 box. I have already read that creating staging tables would be the best way to go. The problem I'm having lies within DTS connecting to the ftp site. So my questions are....1. Is it even possible to transfer from ftp site directly to sql server or do you have to have staging location first.2. ftp path is ftp://username:password@jd2sks01.hdhdj.ceww.com/but when i open ftp task in dts and enter just ftp://jd2sks01.hdhdj.ceww.com/then put username and password in boxes it says it can't connect?Any ideas would be greatly appreciated. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-03-18 : 13:43:35
|
| You would usually copy the file to a local directory - it will be safer that way and give you a record of what is loaded.I don't use dts for ftp but do it via t-sql using the command line utility.seehttp://www.nigelrivett.net/s_ftp_PutFile.html(it's a put but the get is the same).For importing files seehttp://www.nigelrivett.net/ImportTextFiles.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jjw
Starting Member
9 Posts |
Posted - 2004-03-18 : 14:30:03
|
| I've actually seen this site before. Examples look good but I don't have permission to run cmdshell proc. I'm going downstairs to talk with database team and let you know what they tell me. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-18 : 15:00:33
|
nr stands for Nigel Rivett. It's his site.  Tara |
|
|
|
|
|
|
DTS FTP task