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 |
|
Batman
Starting Member
6 Posts |
 Posted - 2004-08-26 : 05:53:45
|
| Hi,I have 2 server. 1 with ms sql en the other with ftp accounts en websites. Now i want to import a file with dts into the database. Has anyone an id how i can connect to the other server. It is to import a txt file.I can only connect to a file on my local machine.GreetzTom |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-26 : 08:48:50
|
quote:
I can only connect to a file on my local machine.
If so - how are you going to get a file off the other server?Can you ftp to the other server? If so you can use an FTP job in DTS to pull the file across onto your database server. |
 |
|
|
Batman
Starting Member
6 Posts |
Posted - 2004-08-26 : 08:50:13
|
| How can I use a ftp job in dts. Please help me. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-26 : 09:55:18
|
| There is an FTP task in the DTS Designer window. It's fairly straight-forward |
|
|
|
Batman
Starting Member
6 Posts |
Posted - 2004-08-27 : 05:51:24
|
| Hoi,Als ik een ftp job gebruik dan kan ik enkel een bestand overzetten. Maar bestaat er een mogelijkheid om een bestand in te laten dat op een anders server blijft staan?Mvg Tom |
|
|
|
|
|
|
Importing from other server