upgraded SSIS 2005 to 2008, FTPWebRequest isssues

• Tobar

  SSCarpal Tunnel

  Points: 4876

  More actions

  July 26, 2012 at 1:08 pm

  #259385

  I am trying to port our code to 2008 but I am having this FTP issue. The FTP connection keeps coming back saying "503: Not logged in". I have verified the credentials more than once so I know I have them correct. My code dies at the "nResponse = CType(nFtpRequest.GetResponse(), FtpWebResponse)" line, (right after Request R is printed). Any help would be appreciated.

  Thanks

  Public Sub Main()

  Dim nCredentials As New NetworkCredential("XX", "XXXXX")

  Dim nFtpRequest As FtpWebRequest = CType(WebRequest.Create("ftp://XXXX"), FtpWebRequest)

  nFtpRequest.ConnectionGroupName = "myConnectionGroup"

  'nFtpRequest.Credentials = nCredentials

  nFtpRequest.Method = WebRequestMethods.Ftp.ListDirectory 'get list of file names

  MsgBox("request Q")

  Dim nResponse As FtpWebResponse

  MsgBox("request R")

  nResponse = CType(nFtpRequest.GetResponse(), FtpWebResponse)

  MsgBox("request Z")

  MsgBox("response is :" & nResponse.ToString)

  Dts.TaskResult = ScriptResults.Success

  End Sub

  <><
  Livin' down on the cube farm. Left, left, then a right.

• Tobar

  SSCarpal Tunnel

  Points: 4876

  More actions

  July 30, 2012 at 7:58 am

  #1519151

  Any thoughts out there? This is a major issue for me so any insights would be useful.

  Thanks.

  <><
  Livin' down on the cube farm. Left, left, then a right.