TechBubbles Microsoft Technology BLOG

TagFTP task in SSIS

Using File System Task and FTP Task in SQL server SSIS

Tasks are fundamental units in SSIS control flow. Every task in SSIS needs to be configure with required fields. This post going to explain how to use FTP and File System task. You can use the File System to automate data load process. Consider a scenario where you receive a file from source system via FTP and your package needs to be react by moving it to another working directory. 1. Create a...

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud