Post reply

FTP Task Error

  • 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,

  • 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

  • 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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply