Skip to content

Instantly share code, notes, and snippets.

@beaudierman

beaudierman/ssis-ftp-hack.cs

Created October 20, 2013 02:50
Show Gist options
  • Save beaudierman/7064336 to your computer and use it in GitHub Desktop.
Save beaudierman/7064336 to your computer and use it in GitHub Desktop.
Download ZIP
Hack for using an FTP Connection Manager in an SSIS package
Raw
ssis-ftp-hack.cs
object ftpConnectionManager = (object)Dts.Connections["FTP Connection Manager"];
string user = "user";
string pass = "pass";
Dts.Connections["FTP Connection Manager"].Properties["ServerUserName"].SetValue(ftpConnectionManager, user);
Dts.Connections["FTP Connection Manager"].Properties["ServerPassword"].SetValue(ftpConnectionManager, pass);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment