FTP Task Error

• Jay Pete

  SSCommitted

  Points: 1945

  More actions

  February 16, 2012 at 1:57 pm

  #264745

  Hi All,

  I try to upload the text file onto FTP Server.

  I had set the package configuration in my package.

  it seems to be everything is looking fine.

  When i try to run the package i got error like that

  ''Enable to Connect using FTP connection manager"

  But i had given the correct user name and password for FTP server.

  Becuase i had checked using TEST CONNECTION

  Would please share your thoughts to troubleshoot this package.

  Thanks,

• MyDoggieJessie

  SSC-Forever

  Points: 44486

  More actions

  February 16, 2012 at 2:06 pm

  #1448143

  This should have probably been posted under the Integration Services forum...

  Can you attach your dtsx package to the post (excluding the FTP IP/username/password info of course)

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• Jay Pete

  SSCommitted

  Points: 1945

  More actions

  February 16, 2012 at 2:23 pm

  #1448161

  Because of security reason, i can't upload

  the .dtsx file here.

  If you don't mind ,would you suggest some workaround to resolve this type error.

  Let me do my self..

  Thanks for your reply

• MyDoggieJessie

  SSC-Forever

  Points: 44486

  More actions

  February 16, 2012 at 2:32 pm

  #1448166

  Use a script task (just to see if that works) something like:

  Public Sub Main()

  Try

  'Create the connection to the ftp server

  Dim cm As ConnectionManager = Dts.Connections.Add("FTP")

  Dim remoteFileNames() As String = {"kibbles"}

  Dim strFolders() As String

  Dim strFiles() As String

  Dim fileName As String

  Dim filefound As Boolean

  'Set the properties like username & password

  cm.Properties("ServerName").SetValue(cm, "FTPServerName") '10.10.10.10

  cm.Properties("ServerUserName").SetValue(cm, "doggie")

  cm.Properties("ServerPassword").SetValue(cm, "w0oF!")

  Dim ftp As FtpClientConnection = New FtpClientConnection(cm.AcquireConnection(Nothing))

  'Connects to the ftp server

  http://ftp.Connect()

  http://ftp.SetWorkingDirectory("/home/treats/chews")

  http://ftp.GetListing(strFolders, strFiles)

  Dts.Variables("FileFound").Value = 0

  ' filefound = False

  For Each fileName In strFiles

  'If the parsed name portion = a day you want

  'then add to the strFilesDownload array

  If fileName.Equals("kibbles") Then

  Dts.Variables("FileFound").Value = 1

  End If

  Next

  http://ftp.Close()

  Catch ex As Exception

  Dts.TaskResult = ScriptResults.Failure

  End Try

  Dts.TaskResult = ScriptResults.Success

  End Sub

  You said that your "test connection" completed successfully correct?

  Out of curiousity, what do you have the ProtectionLevel (on the package level) set at?

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience