|
|
You're in the
sql server dts
group:Dynamic FTP Connection
sql server dts:
I wanted to know how to make a dynamic FTP Connection. My FTP Server will be having a FTP server Name , File path, FTP Server Name, FTP User Name, FTP Password. Our Database maintains different FTP servers for different clients.In DTS we used below code in activex script task to connect to the FTP Dynamically. "Set objTask = objPackage.Tasks(cstr("DTSTask_DTSFTPTask_2")).CustomTask objTask.SourceLocation = 0 objTask.sourcesite = DTSGlobalVariables("g_str_ftpservername").Value objTask.SourceUsername = DTSGlobalVariables("g_str_ftpusername").Value objTask.SourcePassword = DTSGlobalVariables("g_str_ftppassword").Value objTask.NonOverwritable = False objTask.SourceFilename = srcFiles objTask.destsite = DTSGlobalVariables("g_str_filelocation").Value Now we are migrating our workflows to SSIS (SQL Server 2005). The problem is we are unable to find solution for dynamically connecting to FTP Server which maintains a password. Can any body help please. Thanks, Kiran G
Create your FTP connection manager (with static values). Create a package
configuration by selecting Package Configurations from the SSIS menu, then export the ConnectionString, ServerName, ServerPassword and ServerUserName properties of the FTP connection manager to the package configuration location. Save your package configuration to an XML file or to a SQL Server table, because they allow multiple values to be saved. Each time you want new values for ServerName, ServerPassword, etc. you just enter them into the configuration file or SQL Server table. This way your package will run dynamically with the whatever values you have saved in your package configuration. The SSIS tutorial also shows you how to create a package configuration. Hope this helps. Charles Kangai, MCT, MCDBA Author of Learning Tree's 4-day course: "SQL Server 2005 Integration Services" URL: http://www.learningtree.com/courses/134.htm Author of Learning Tree's 4-day course: "SQL Server Reporting Services" URL: http://www.learningtree.com/courses/523.htm [quoted text, click to view] "kiran" wrote:
> Hello , > I wanted to know how to make a dynamic FTP Connection. My > FTP Server will be having a FTP server Name , File path, FTP Server > Name, FTP User Name, FTP Password. Our Database maintains different FTP > servers for different clients.In DTS we used below code in activex > script task to connect to the FTP Dynamically. > > > "Set objTask = > objPackage.Tasks(cstr("DTSTask_DTSFTPTask_2")).CustomTask > > objTask.SourceLocation = 0 > objTask.sourcesite = DTSGlobalVariables("g_str_ftpservername").Value > objTask.SourceUsername = DTSGlobalVariables("g_str_ftpusername").Value > objTask.SourcePassword = DTSGlobalVariables("g_str_ftppassword").Value > objTask.NonOverwritable = False > objTask.SourceFilename = srcFiles > objTask.destsite = DTSGlobalVariables("g_str_filelocation").Value > > Now we are migrating our workflows to SSIS (SQL Server > 2005). The problem is we are unable to find solution for dynamically > connecting to FTP Server which maintains a password. > Can any body help please. > Thanks, > Kiran G >
[quoted text, click to view] Charles Kangai wrote: > Create your FTP connection manager (with static values). Create a package > configuration by selecting Package Configurations from the SSIS menu, then > export the ConnectionString, ServerName, ServerPassword and ServerUserName > properties of the FTP connection manager to the package configuration > location. Save your package configuration to an XML file or to a SQL Server > table, because they allow multiple values to be saved. > > Each time you want new values for ServerName, ServerPassword, etc. you just > enter them into the configuration file or SQL Server table. This way your > package will run dynamically with the whatever values you have saved in your > package configuration. > > The SSIS tutorial also shows you how to create a package configuration. > > Hope this helps. > > Charles Kangai, MCT, MCDBA > > Author of Learning Tree's 4-day course: "SQL Server 2005 Integration > Services" URL: http://www.learningtree.com/courses/134.htm > Author of Learning Tree's 4-day course: "SQL Server Reporting Services" URL: > http://www.learningtree.com/courses/523.htm > > > > > > > "kiran" wrote: > > > Hello , > > I wanted to know how to make a dynamic FTP Connection. My > > FTP Server will be having a FTP server Name , File path, FTP Server > > Name, FTP User Name, FTP Password. Our Database maintains different FTP > > servers for different clients.In DTS we used below code in activex > > script task to connect to the FTP Dynamically. > > > > > > "Set objTask = > > objPackage.Tasks(cstr("DTSTask_DTSFTPTask_2")).CustomTask > > > > objTask.SourceLocation = 0 > > objTask.sourcesite = DTSGlobalVariables("g_str_ftpservername").Value > > objTask.SourceUsername = DTSGlobalVariables("g_str_ftpusername").Value > > objTask.SourcePassword = DTSGlobalVariables("g_str_ftppassword").Value > > objTask.NonOverwritable = False > > objTask.SourceFilename = srcFiles > > objTask.destsite = DTSGlobalVariables("g_str_filelocation").Value > > > > Now we are migrating our workflows to SSIS (SQL Server > > 2005). The problem is we are unable to find solution for dynamically > > connecting to FTP Server which maintains a password. > > Can any body help please. > > Thanks, > > Kiran G > > > > Thanks Charles Kangai , It was really useful.It is working.. Thank You. Now the 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
I have tried this method for an Oracle connection, both with SQL Server and
XML. When running the package, I get an error "Invalid username/password). I check the password, and it's **** in db and blank in the xml file. I type the correct password, but it still does not work. Have you tried this with an Oracle connection? [quoted text, click to view] "Charles Kangai" wrote:
> Create your FTP connection manager (with static values). Create a package > configuration by selecting Package Configurations from the SSIS menu, then > export the ConnectionString, ServerName, ServerPassword and ServerUserName > properties of the FTP connection manager to the package configuration > location. Save your package configuration to an XML file or to a SQL Server > table, because they allow multiple values to be saved. > > Each time you want new values for ServerName, ServerPassword, etc. you just > enter them into the configuration file or SQL Server table. This way your > package will run dynamically with the whatever values you have saved in your > package configuration. > > The SSIS tutorial also shows you how to create a package configuration. > > Hope this helps. > > Charles Kangai, MCT, MCDBA > > Author of Learning Tree's 4-day course: "SQL Server 2005 Integration > Services" URL: http://www.learningtree.com/courses/134.htm > Author of Learning Tree's 4-day course: "SQL Server Reporting Services" URL: > http://www.learningtree.com/courses/523.htm > > > > > > > "kiran" wrote: > > > Hello , > > I wanted to know how to make a dynamic FTP Connection. My > > FTP Server will be having a FTP server Name , File path, FTP Server > > Name, FTP User Name, FTP Password. Our Database maintains different FTP > > servers for different clients.In DTS we used below code in activex > > script task to connect to the FTP Dynamically. > > > > > > "Set objTask = > > objPackage.Tasks(cstr("DTSTask_DTSFTPTask_2")).CustomTask > > > > objTask.SourceLocation = 0 > > objTask.sourcesite = DTSGlobalVariables("g_str_ftpservername").Value > > objTask.SourceUsername = DTSGlobalVariables("g_str_ftpusername").Value > > objTask.SourcePassword = DTSGlobalVariables("g_str_ftppassword").Value > > objTask.NonOverwritable = False > > objTask.SourceFilename = srcFiles > > objTask.destsite = DTSGlobalVariables("g_str_filelocation").Value > > > > Now we are migrating our workflows to SSIS (SQL Server > > 2005). The problem is we are unable to find solution for dynamically > > connecting to FTP Server which maintains a password. > > Can any body help please. > > Thanks, > > Kiran G > >
Can you please describe in brief, How this can be don -- Deepes ----------------------------------------------------------------------- Deepesh's Profile: http://www.dbtalk.net/m81 View this thread: http://www.dbtalk.net/t32862
[quoted text, click to view] Charles Kangai Wrote: > Create your FTP connection manager (with static values). Create > package > configuration by selecting Package Configurations from the SSIS menu > then > export the ConnectionString, ServerName, ServerPassword an > ServerUserName > properties of the FTP connection manager to the package configuration > location. Save your package configuration to an XML file or to a SQ > Server > table, because they allow multiple values to be saved. > > Each time you want new values for ServerName, ServerPassword, etc. yo > just > enter them into the configuration file or SQL Server table. This wa > your > package will run dynamically with the whatever values you have saved i > your > package configuration. > > The SSIS tutorial also shows you how to create a packag > configuration. > > Hope this helps. > > Charles Kangai, MCT, MCDBA > > Author of Learning Tree's 4-day course: "SQL Server 2005 Integration > Services" URL: http://www.learningtree.com/courses/134.htm > Author of Learning Tree's 4-day course: "SQL Server Reporting Services > URL: > http://www.learningtree.com/courses/523.htm > > > > > > > Hi I have tried that, in the configuration file I have added tw > connection for two different FTP location but the last one work in al > the cases. The file is not fetched from the first location -- Deepes ----------------------------------------------------------------------- Deepesh's Profile: http://www.dbtalk.net/m81 View this thread: http://www.dbtalk.net/t32862
I have solved the task. Thanks, Deepesh Verm -- Deepes ----------------------------------------------------------------------- Deepesh's Profile: http://www.dbtalk.net/m81 View this thread: http://www.dbtalk.net/t32862
Thats for ur soln. But My problem is not how to dynamically connect to
FTP Server which is having password [quoted text, click to view] Deepesh wrote:
> I have solved the task. > > Thanks, > Deepesh Verma > > > -- > Deepesh > ------------------------------------------------------------------------ > Deepesh's Profile: http://www.dbtalk.net/m818 > View this thread: http://www.dbtalk.net/t328627
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 |