send file data using AWS AppFlow

Hey, please check the below link, this may help you.

https://medium.com/tensult/aws-transfer-for-sftp-secure-shell-file-transfer-protocol-f37e09f94813

You can transfer file using WinSCP also. Please check the below code.

Namespace to use: using WinSCP;

readonly string sHostName = "host neme/ ip";
readonly string sUserName = "user_name";
readonly string sPassword = "your password";
readonly string sSshHostKey = "your SSHHostKey";
readonly string sFilePath = @"your local file path";
readonly string sToFilePath = "S3 folder path";
public void CopyFiles(string sFilePath)
{
try
{
// Setup session options
SessionOptions sessionOptions = new SessionOptions
{
Protocol = Protocol.Sftp,
HostName = sHostName,
UserName = sUserName,
Password = sPassword,
SshHostKeyFingerprint = sSshHostKey
};
using (Session session = new Session())
{
// Connect
session.Open(sessionOptions);
// Upload files
TransferOptions transferOptions = new TransferOptions
{
TransferMode = TransferMode.Binary
};
TransferOperationResult transferResult;
transferResult =
session.PutFiles(sFilePath, sToFilePath, false, transferOptions);
// Throw on any error
transferResult.Check();
// Print results
foreach (TransferEventArgs transfer in transferResult.Transfers)
{
Console.WriteLine(string.Format("Upload of {0} succeeded", transfer.FileName));
}
}
}
catch (Exception e)
{
Console.WriteLine(string.Format("Error: {0}", e));
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ritu4y ago
Hi,

I want to access the SQL Server instance on an aws appflow.
is this possible? if yes can u provide some solution in c#
0
Amit Mohanty4y ago
Hey, please check the below link, this may help you.

https://medium.com/tensult/aws-transfer-for-sftp-secure-shell-file-transfer-protocol-f37e09f94813

You can transfer file using WinSCP also. Please check the below code.
Namespace to use: using WinSCP;
readonly string sHostName = "host neme/ ip";
readonly string sUserName = "user_name";
readonly string sPassword = "your password";
readonly string sSshHostKey = "your SSHHostKey";

readonly string sFilePath = @"your local file path";
readonly string sToFilePath = "S3 folder path";
public void CopyFiles(string sFilePath)
{
    try
    {
        // Setup session options
        SessionOptions sessionOptions = new SessionOptions
        {
            Protocol = Protocol.Sftp,
            HostName = sHostName,
            UserName = sUserName,
            Password = sPassword,
            SshHostKeyFingerprint = sSshHostKey
        };

        using (Session session = new Session())
        {
            // Connect
            session.Open(sessionOptions);

            // Upload files
            TransferOptions transferOptions = new TransferOptions
            {
                TransferMode = TransferMode.Binary
            };

            TransferOperationResult transferResult;
            transferResult =
                session.PutFiles(sFilePath, sToFilePath, false, transferOptions);

            // Throw on any error
            transferResult.Check();

            // Print results
            foreach (TransferEventArgs transfer in transferResult.Transfers)
            {
                Console.WriteLine(string.Format("Upload of {0} succeeded", transfer.FileName));
            }
        }
    }
    catch (Exception e)
    {
        Console.WriteLine(string.Format("Error: {0}", e));
    }
}
0