?
Solved

SSIS Ftp Connection Manager

Posted on 2006-05-21
10
Medium Priority
?
2,158 Views
Last Modified: 2013-12-03
Hello All,

I'm working on a SSIS Package. I would like an example for FTP ConnectionString to create FTP Connection at Run-Time.
I have a private variable in my class:

Private ConMgr As ConnectionManager.
Public Sub Main()

ConMgr = Dts.Connections.Add("FTP")
ConMgr.ConnectionString =
End Sub

I want to know the conection string for a FTP connection where I can specify server name, userid and password.

Please help.

Thanks.
0
Comment
Question by:csuser
  • 5
  • 3
8 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16729698
0
 

Author Comment

by:csuser
ID: 16734916
Already looked at this article. There is no connectionstring example given for connection type FTP. I need an example for FTP Connection Type.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16735612
Interestingly enough, I did see one:
ConMgr.ConnectionString = @"\\<yourserver>\<yourfolder>\books.xml";
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:csuser
ID: 16735782
That is really an example for connections of type File!

ConMgr = p.Connections.Add("File");
ConMgr.ConnectionString = @"\\<yourserver>\<yourfolder>\books.xml";

I want similar example for connections of type FTP where I can specify ServerName, ServerUserName, ServerPassword and ServerPort.


0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16735861
I see I misunderstood that page.
Let me fire up my sql 2005 vm box to check it out...
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16736453
I tested with my setup, and found that you simply put the following:

ConMgr.ConnectionString = @"servername_or_ip:port";
0
 

Author Comment

by:csuser
ID: 16736708
OK..How do I specify UserName and Password in connectionstring?
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 240 total points
ID: 16739761
well, adding uid=username;pwd=password; to the conneciton string;
ConMgr.ConnectionString = @"servername_or_ip:port;uid=username;pwd=password;";

or, please try the internet style:
ConMgr.ConnectionString = @"username:password@servername_or_ip:port";
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question