Unable to start my SSIS package

Question

I created and deployed a package for SQL Server 2005. The package basically uploads a file (.csv) via FTP and extracts the contents to a table. The data is cleared and then the data is moved to the production table.

After deploying the package, I tried to call it from a simple .NET application

      Dim app As New Application
    Dim pkg As Package

    Try
        pkg = app.LoadFromSqlServer("OrderImport", "machine\dataware", "sa", "sapassword", Nothing)

        Dim result As DTSExecResult = pkg.Execute()
        MsgBox(result.ToString)
    Catch ex As Exception
        MsgBox(ex.Message)
    Finally
        app = Nothing
        pkg = Nothing
    End Try

and received the message "Failure". Then I went to SSIS through Management Studio and tried to execute the package from there. It is able to upload files via FTP, however, when it reaches the .CSV file at the point to extract data, it shows an error

The system cannot find the file specified
ERROR: Cannot open the datafile filename.csv

What else can I look at? I want to be able to run a package with SQL Server accounts, if possible.

At the package level, I have

ProtectionLevel = EncryptSensitiveWithUserKey
PackagePassword = [BLANK]

One more thing - how do I write these errors to a file?

Answer 1

ftp , , , ? .

, SSIS , , .