|
|
You're in the
sql server dts
group:Downloading Files From FTP Site
sql server dts:
This question is regarding downloading a file from an FTP Server to local (through SSIS FTP Task). I have 2 questions to ask you. 1. I have Downloaded a file of 5.5 MB from FTP Server to Local through (SSIS FTP Task).It took nearly 4 Minutes 20 seconds (Nearly). Is there any method to download a file from an FTP Server to local (through SSIS FTP Task)? (These are Just the test results.). 2. I have a set of Files to download from an FTP.I am using FTP Task in a loop to download each file.Now I think Each Time It passes through the FTP Task Is connection to the Server.Obviously there is a time delay. is there any method through which i can call the FTP task only once to download those set Of files.? Thnaks, Kiran G
Hi Kiran,
I can answer your second question, i.e. whether you can download multiple files in one operation. The answer is Yes. What you do is: 1) Create a variable and set its value to the wildcard of the files you want to download. 2) On the File Transfer page of the FTP task, set the Operation property to "Receive Files" 3) Set the IsRemotePathVariable property to True. 4) Set the RemoteVariable property to the variable you created in Step 1. 5) Specify the LocalPath property and set any other properties. I didn't understand your first question. You are saying that you have downloaded a file from an FTP server to local, but then you are asking whether it is possible? Regards, Charles Kangai, MCT, MCDBA Author of Learning Tree's 4-day course: "SQL Server 2005 Integration Services" http://www.learningtree.com/courses/134.htm Author of Learning Tree's 4-day course: "SQL Server Reporting Services" http://www.learningtree.com/courses/523.htm [quoted text, click to view] "kiran" wrote:
> Hi all, > > > This question is regarding downloading a > file from an FTP Server to local (through SSIS FTP Task). I have 2 > questions to ask you. > 1. I have Downloaded a file of 5.5 MB from FTP Server to Local through > (SSIS FTP Task).It took nearly 4 Minutes 20 seconds (Nearly). Is there > any method to download a file from an FTP Server to local (through SSIS > FTP Task)? (These are Just the test results.). > > 2. I have a set of Files to download from an FTP.I am using FTP Task > in a loop to download each file.Now I think Each Time It passes through > the FTP Task Is connection to the Server.Obviously there is a time > delay. is there any method through which i can call the FTP task only > once to download those set Of files.? > Thnaks, > Kiran G >
Hi Charles,
This is regarding your answer to my second question.Thanks for your Input. By saying "Wildcard" you mean to say for ex. : "/path/ a.*" or may be "/path/ *.zip" ?. This works. But What i really need is ..I will give you an example. Let me say I have some 20 - 30 files in a location , say, FTP.SERVER.COM and the path initially where the files are available is say \PATH\. Now I have 20 files, say, 1. k1.txt 2. ds2.xls 3 . \inerpath\kn.jpg 4 . pr.zip 5. abc.lmn .. .. .. .. 20. an.klp Now, I will select only 6 files say file No 1 ,4, 7,8 ,9 and 20. I to download these 6 files I have to loop through each file to download files. Now I dont want the loop.I just want get into the FTP task "once" and select only the above 6 files and download these files. Is this possible? Thanks, Kiran [quoted text, click to view] Charles Kangai wrote:
> Hi Kiran, > > I can answer your second question, i.e. whether you can download multiple > files in one operation. The answer is Yes. What you do is: > > 1) Create a variable and set its value to the wildcard of the files you want > to download. > 2) On the File Transfer page of the FTP task, set the Operation property to > "Receive Files" > 3) Set the IsRemotePathVariable property to True. > 4) Set the RemoteVariable property to the variable you created in Step 1. > 5) Specify the LocalPath property and set any other properties. > > I didn't understand your first question. You are saying that you have > downloaded a file from an FTP server to local, but then you are asking > whether it is possible? > > Regards, > > > Charles Kangai, MCT, MCDBA > > Author of Learning Tree's 4-day course: "SQL Server 2005 Integration > Services" http://www.learningtree.com/courses/134.htm > Author of Learning Tree's 4-day course: "SQL Server Reporting Services" > http://www.learningtree.com/courses/523.htm > > > > > > > > "kiran" wrote: > > > Hi all, > > > > > > This question is regarding downloading a > > file from an FTP Server to local (through SSIS FTP Task). I have 2 > > questions to ask you. > > 1. I have Downloaded a file of 5.5 MB from FTP Server to Local through > > (SSIS FTP Task).It took nearly 4 Minutes 20 seconds (Nearly). Is there > > any method to download a file from an FTP Server to local (through SSIS > > FTP Task)? (These are Just the test results.). > > > > 2. I have a set of Files to download from an FTP.I am using FTP Task > > in a loop to download each file.Now I think Each Time It passes through > > the FTP Task Is connection to the Server.Obviously there is a time > > delay. is there any method through which i can call the FTP task only > > once to download those set Of files.? > > Thnaks, > > Kiran G > > > >
Unless there is a trick I have missed, the only way to specify multiple files
is by using a wildcard. You cannot specify a comma separated list of the files you want. But I can see that it would be nice to have such a feature. Charles Kangai, MCT, MCDBA Author of Learning Tree's 4-day course: "SQL Server 2005 Integration Services" http://www.learningtree.com/courses/134.htm Author of Learning Tree's 4-day course: "SQL Server Reporting Services" http://www.learningtree.com/courses/523.htm [quoted text, click to view] "kiran" wrote:
> Hi Charles, > This is regarding your answer to my second > question.Thanks for your Input. By saying "Wildcard" you mean to say > for ex. : "/path/ a.*" or may be "/path/ *.zip" ?. This works. But What > i really need is ..I will give you an example. > Let me say I have some 20 - 30 files in a location , say, > FTP.SERVER.COM and the path initially where the files are available is > say \PATH\. Now I have 20 files, say, > > 1. k1.txt > 2. ds2.xls > 3 . \inerpath\kn.jpg > 4 . pr.zip > 5. abc.lmn > .. > .. > .. > .. > > 20. an.klp > > Now, I will select only 6 files say file No 1 ,4, > 7,8 ,9 and 20. I to download these 6 files I have to loop through each > file to download files. Now I dont want the loop.I just want get into > the FTP task "once" and select only the above 6 files and download > these files. Is this possible? > Thanks, > Kiran > > > > > Charles Kangai wrote: > > Hi Kiran, > > > > I can answer your second question, i.e. whether you can download multiple > > files in one operation. The answer is Yes. What you do is: > > > > 1) Create a variable and set its value to the wildcard of the files you want > > to download. > > 2) On the File Transfer page of the FTP task, set the Operation property to > > "Receive Files" > > 3) Set the IsRemotePathVariable property to True. > > 4) Set the RemoteVariable property to the variable you created in Step 1. > > 5) Specify the LocalPath property and set any other properties. > > > > I didn't understand your first question. You are saying that you have > > downloaded a file from an FTP server to local, but then you are asking > > whether it is possible? > > > > Regards, > > > > > > Charles Kangai, MCT, MCDBA > > > > Author of Learning Tree's 4-day course: "SQL Server 2005 Integration > > Services" http://www.learningtree.com/courses/134.htm > > Author of Learning Tree's 4-day course: "SQL Server Reporting Services" > > http://www.learningtree.com/courses/523.htm > > > > > > > > > > > > > > > > "kiran" wrote: > > > > > Hi all, > > > > > > > > > This question is regarding downloading a > > > file from an FTP Server to local (through SSIS FTP Task). I have 2 > > > questions to ask you. > > > 1. I have Downloaded a file of 5.5 MB from FTP Server to Local through > > > (SSIS FTP Task).It took nearly 4 Minutes 20 seconds (Nearly). Is there > > > any method to download a file from an FTP Server to local (through SSIS > > > FTP Task)? (These are Just the test results.). > > > > > > 2. I have a set of Files to download from an FTP.I am using FTP Task > > > in a loop to download each file.Now I think Each Time It passes through > > > the FTP Task Is connection to the Server.Obviously there is a time > > > delay. is there any method through which i can call the FTP task only > > > once to download those set Of files.? > > > Thnaks, > > > Kiran G > > > > > > >
[quoted text, click to view] Charles Kangai wrote: Hi charles,> Unless there is a trick I have missed, the only way to specify multiple files > is by using a wildcard. You cannot specify a comma separated list of the > files you want. But I can see that it would be nice to have such a feature. > > Charles Kangai, MCT, MCDBA > > Author of Learning Tree's 4-day course: "SQL Server 2005 Integration > Services" http://www.learningtree.com/courses/134.htm > Author of Learning Tree's 4-day course: "SQL Server Reporting Services" > http://www.learningtree.com/courses/523.htm > > > > "kiran" wrote: > > > Hi Charles, > > This is regarding your answer to my second > > question.Thanks for your Input. By saying "Wildcard" you mean to say > > for ex. : "/path/ a.*" or may be "/path/ *.zip" ?. This works. But What > > i really need is ..I will give you an example. > > Let me say I have some 20 - 30 files in a location , say, > > FTP.SERVER.COM and the path initially where the files are available is > > say \PATH\. Now I have 20 files, say, > > > > 1. k1.txt > > 2. ds2.xls > > 3 . \inerpath\kn.jpg > > 4 . pr.zip > > 5. abc.lmn > > .. > > .. > > .. > > .. > > > > 20. an.klp > > > > Now, I will select only 6 files say file No 1 ,4, > > 7,8 ,9 and 20. I to download these 6 files I have to loop through each > > file to download files. Now I dont want the loop.I just want get into > > the FTP task "once" and select only the above 6 files and download > > these files. Is this possible? > > Thanks, > > Kiran > > > > > > > > > > Charles Kangai wrote: > > > Hi Kiran, > > > > > > I can answer your second question, i.e. whether you can download multiple > > > files in one operation. The answer is Yes. What you do is: > > > > > > 1) Create a variable and set its value to the wildcard of the files you want > > > to download. > > > 2) On the File Transfer page of the FTP task, set the Operation property to > > > "Receive Files" > > > 3) Set the IsRemotePathVariable property to True. > > > 4) Set the RemoteVariable property to the variable you created in Step 1. > > > 5) Specify the LocalPath property and set any other properties. > > > > > > I didn't understand your first question. You are saying that you have > > > downloaded a file from an FTP server to local, but then you are asking > > > whether it is possible? > > > > > > Regards, > > > > > > > > > Charles Kangai, MCT, MCDBA > > > > > > Author of Learning Tree's 4-day course: "SQL Server 2005 Integration > > > Services" http://www.learningtree.com/courses/134.htm > > > Author of Learning Tree's 4-day course: "SQL Server Reporting Services" > > > http://www.learningtree.com/courses/523.htm > > > > > > > > > > > > > > > > > > > > > > > > "kiran" wrote: > > > > > > > Hi all, > > > > > > > > > > > > This question is regarding downloading a > > > > file from an FTP Server to local (through SSIS FTP Task). I have 2 > > > > questions to ask you. > > > > 1. I have Downloaded a file of 5.5 MB from FTP Server to Local through > > > > (SSIS FTP Task).It took nearly 4 Minutes 20 seconds (Nearly). Is there > > > > any method to download a file from an FTP Server to local (through SSIS > > > > FTP Task)? (These are Just the test results.). > > > > > > > > 2. I have a set of Files to download from an FTP.I am using FTP Task > > > > in a loop to download each file.Now I think Each Time It passes through > > > > the FTP Task Is connection to the Server.Obviously there is a time > > > > delay. is there any method through which i can call the FTP task only > > > > once to download those set Of files.? > > > > Thnaks, > > > > Kiran G > > > > > > > > > > > > We used to do the same thing in DTS. It was possible there. But Its not possible now In SSIS.
I am not a Microsoft person. But I do hope they read these posts.
Cheers, Charles Kangai, MCT, MCDBA Author of Learning Tree's 4-day course: "SQL Server 2005 Integration Services" http://www.learningtree.com/courses/134.htm Author of Learning Tree's 4-day course: "SQL Server Reporting Services" http://www.learningtree.com/courses/523.htm [quoted text, click to view] "kiran" wrote:
> > Charles Kangai wrote: > > Unless there is a trick I have missed, the only way to specify multiple files > > is by using a wildcard. You cannot specify a comma separated list of the > > files you want. But I can see that it would be nice to have such a feature. > > > > Charles Kangai, MCT, MCDBA > > > > Author of Learning Tree's 4-day course: "SQL Server 2005 Integration > > Services" http://www.learningtree.com/courses/134.htm > > Author of Learning Tree's 4-day course: "SQL Server Reporting Services" > > http://www.learningtree.com/courses/523.htm > > > > > > > > "kiran" wrote: > > > > > Hi Charles, > > > This is regarding your answer to my second > > > question.Thanks for your Input. By saying "Wildcard" you mean to say > > > for ex. : "/path/ a.*" or may be "/path/ *.zip" ?. This works. But What > > > i really need is ..I will give you an example. > > > Let me say I have some 20 - 30 files in a location , say, > > > FTP.SERVER.COM and the path initially where the files are available is > > > say \PATH\. Now I have 20 files, say, > > > > > > 1. k1.txt > > > 2. ds2.xls > > > 3 . \inerpath\kn.jpg > > > 4 . pr.zip > > > 5. abc.lmn > > > .. > > > .. > > > .. > > > .. > > > > > > 20. an.klp > > > > > > Now, I will select only 6 files say file No 1 ,4, > > > 7,8 ,9 and 20. I to download these 6 files I have to loop through each > > > file to download files. Now I dont want the loop.I just want get into > > > the FTP task "once" and select only the above 6 files and download > > > these files. Is this possible? > > > Thanks, > > > Kiran > > > > > > > > > > > > > > > Charles Kangai wrote: > > > > Hi Kiran, > > > > > > > > I can answer your second question, i.e. whether you can download multiple > > > > files in one operation. The answer is Yes. What you do is: > > > > > > > > 1) Create a variable and set its value to the wildcard of the files you want > > > > to download. > > > > 2) On the File Transfer page of the FTP task, set the Operation property to > > > > "Receive Files" > > > > 3) Set the IsRemotePathVariable property to True. > > > > 4) Set the RemoteVariable property to the variable you created in Step 1. > > > > 5) Specify the LocalPath property and set any other properties. > > > > > > > > I didn't understand your first question. You are saying that you have > > > > downloaded a file from an FTP server to local, but then you are asking > > > > whether it is possible? > > > > > > > > Regards, > > > > > > > > > > > > Charles Kangai, MCT, MCDBA > > > > > > > > Author of Learning Tree's 4-day course: "SQL Server 2005 Integration > > > > Services" http://www.learningtree.com/courses/134.htm > > > > Author of Learning Tree's 4-day course: "SQL Server Reporting Services" > > > > http://www.learningtree.com/courses/523.htm > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > "kiran" wrote: > > > > > > > > > Hi all, > > > > > > > > > > > > > > > This question is regarding downloading a > > > > > file from an FTP Server to local (through SSIS FTP Task). I have 2 > > > > > questions to ask you. > > > > > 1. I have Downloaded a file of 5.5 MB from FTP Server to Local through > > > > > (SSIS FTP Task).It took nearly 4 Minutes 20 seconds (Nearly). Is there > > > > > any method to download a file from an FTP Server to local (through SSIS > > > > > FTP Task)? (These are Just the test results.). > > > > > > > > > > 2. I have a set of Files to download from an FTP.I am using FTP Task > > > > > in a loop to download each file.Now I think Each Time It passes through > > > > > the FTP Task Is connection to the Server.Obviously there is a time > > > > > delay. is there any method through which i can call the FTP task only > > > > > once to download those set Of files.? > > > > > Thnaks, > > > > > Kiran G > > > > > > > > > > > > > > > > > Hi charles, > We used to do the same thing in DTS. It was possible > there. But Its not possible now In SSIS. >
As per my knowledge
1) Create a batch file in which it should connect to the ftp server and open a connection by using uid,pwd and use a get method indiacating some files on the ftp server and give the dstination address in the batch file.save and close.Now run the batch file the task is complete. -- Kranthi Kumar Y [quoted text, click to view] "kiran" wrote:
> Hi all, > > > This question is regarding downloading a > file from an FTP Server to local (through SSIS FTP Task). I have 2 > questions to ask you. > 1. I have Downloaded a file of 5.5 MB from FTP Server to Local through > (SSIS FTP Task).It took nearly 4 Minutes 20 seconds (Nearly). Is there > any method to download a file from an FTP Server to local (through SSIS > FTP Task)? (These are Just the test results.). > > 2. I have a set of Files to download from an FTP.I am using FTP Task > in a loop to download each file.Now I think Each Time It passes through > the FTP Task Is connection to the Server.Obviously there is a time > delay. is there any method through which i can call the FTP task only > once to download those set Of files.? > Thnaks, > Kiran G >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |