Scribd
Upload
5 views1 page

File Transfer and Database Storage Guide

The document outlines a process for moving files from an 'in' folder to a 'done' folder by appending the date to the file names. It details the use of an SSH connection manager and a file transfer task to retrieve a remote file list, followed by storing the values in a database using a script task. Proper namespaces and references are emphasized to avoid errors during the implementation.

Uploaded by

Piyush Gupta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views1 page

File Transfer and Database Storage Guide

The document outlines a process for moving files from an 'in' folder to a 'done' folder by appending the date to the file names. It details the use of an SSH connection manager and a file transfer task to retrieve a remote file list, followed by storing the values in a database using a script task. Proper namespaces and references are emphasized to avoid errors during the implementation.

Uploaded by

Piyush Gupta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1. Moving files from in folder to done folder by appending date with the file name.

 Connection manager properties use expression task so that edit from outside.
 Use SSH connection manager to create connection at port no 22 in this case.
 Then use file transfer task with type as get remote file list

Tasks did today in order:

First we got the file list through a file transfer task stored in a local variable defined with object data
type.

Then using a script task we need to store the values in the table in a column in a different variable
with string data [Link] edit the script task.

Take care of using proper and all namespaces. Especially


using [Link];

if there is a error a reference might not be added so we need to add the appropriate
reference like c sharp framework or extension [Link]

then we store the file list in database in a table along with Batch_id and getdate
columns as keys to find which values are getting populated by running the task.

You might also like