 | |
Re: "FTP file using DTS"
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: "FTP file using DTS" -
05-11-2005
, 10:59 AM
|
Hi, I have two servers (I logon locally, but both are in a domain). And I have to use DTS to transfer some zip files and after use ftp. Well, I don磘 want to left map the another server. I wanna using in the box of the component of destination field : \\10.10.10.10\dts But when I close I am not permmited to do it because it don磘 find the server. Have I solution for this ? Thx, M鬾ica |
#2
| |||
| |||
|
|
Hi, thx. But I don麓t know if I am asking correctling... I am using : The File Transfer Protocol (FTP) task And in BOL I search something like that : "FTP task lets you download data files from a remote server or an Internet location as part of a Data Transformation Services (DTS) package workflow." But that is not ok... could you help me ? "Jim Vierra" wrote: You cannot ftp from a file share. You need to have an FTP service running on remote server and it has to have the files in it's directory - not just anywhere on the server. You are safer and better of using file sharing and a copy command. -- Jim Vierra "M么nica" <M么nica (AT) discussions (DOT) microsoft.com> wrote in message news:86E8C640-BDF9-4A0A-AC67-780E8818F35A (AT) microsoft (DOT) com... Hi, I have two servers (I logon locally, but both are in a domain). And I have to use DTS to transfer some zip files and after use ftp. Well, I don麓t want to left map the another server. I wanna using in the box of the component of destination field : \\10.10.10.10\dts But when I close I am not permmited to do it because it don麓t find the server. Have I solution for this ? Thx, M么nica |
#3
| |||
| |||
|
|
Hi, thx for your answer, but I think that I not explained very well. I used The File Transfer Protocol (FTP) task and I saw in BOL that " FTP task lets you download data files from a remote server or an Internet location as part of a Data Transformation Services (DTS) package workflow.". But this is not ok for me... and in your answer you say that is not possible ftp from a file share ! I have on remote server a start ftp service. And I want to recover some file and move to this remote server... that is possible ? Using this ftp task !? I test ftp service.. and i could connect. Thanks "Jim Vierra" wrote: You cannot ftp from a file share. You need to have an FTP service running on remote server and it has to have the files in it's directory - not just anywhere on the server. You are safer and better of using file sharing and a copy command. -- Jim Vierra "M鬾ica" <M鬾ica (AT) discussions (DOT) microsoft.com> wrote in message news:86E8C640-BDF9-4A0A-AC67-780E8818F35A (AT) microsoft (DOT) com... Hi, I have two servers (I logon locally, but both are in a domain). And I have to use DTS to transfer some zip files and after use ftp. Well, I don磘 want to left map the another server. I wanna using in the box of the component of destination field : \\10.10.10.10\dts But when I close I am not permmited to do it because it don磘 find the server. Have I solution for this ? Thx, M鬾ica |
#4
| |||
| |||
|
|
Hi, I create one package, then i make a zip file on server1(local) and i want send (ftp) to server2(remote) using ftp task. When I configure ftp task - destiny directory i put \\10.10.10.10\dts, but i don磘 have success. If I do before : net use \\\\10.10.10.10\dts /user:xxx YYY I have success, but i don't want use it... because I think that is not secure. Thanks for your help "Jim Vierra" wrote: It is possible. What is the problem you are having? -- Jim Vierra "M鬾ica" <Mnica (AT) discussions (DOT) microsoft.com> wrote in message news:EEBDD7DA-D50D-44F8-8574-94FD5F310064 (AT) microsoft (DOT) com... Hi, thx for your answer, but I think that I not explained very well. I used The File Transfer Protocol (FTP) task and I saw in BOL that " FTP task lets you download data files from a remote server or an Internet location as part of a Data Transformation Services (DTS) package workflow.". But this is not ok for me... and in your answer you say that is not possible ftp from a file share ! I have on remote server a start ftp service. And I want to recover some file and move to this remote server... that is possible ? Using this ftp task !? I test ftp service.. and i could connect. Thanks "Jim Vierra" wrote: You cannot ftp from a file share. You need to have an FTP service running on remote server and it has to have the files in it's directory - not just anywhere on the server. You are safer and better of using file sharing and a copy command. -- Jim Vierra "M鬾ica" <M鬾ica (AT) discussions (DOT) microsoft.com> wrote in message news:86E8C640-BDF9-4A0A-AC67-780E8818F35A (AT) microsoft (DOT) com... Hi, I have two servers (I logon locally, but both are in a domain). And I have to use DTS to transfer some zip files and after use ftp. Well, I don磘 want to left map the another server. I wanna using in the box of the component of destination field : \\10.10.10.10\dts But when I close I am not permmited to do it because it don磘 find the server. Have I solution for this ? Thx, M鬾ica |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.