How to Make your FTP Connection Manager Dynamic in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

In this video we are going to learn how to use Variables/Parameters to save the values for FTP Server, User Name, Password, Remote Path, Local Path as these can change according to the environment ( SIT, QA,UAT and production)

The goal is not to make any changes in our SSIS Package and use the Variables/ Parameters to make our SSIS Package more dynamic and pass values to these Variables/Parameters by using SSIS Configuration according to the environment is will run such as QA,UAT,SIT, Prod.

What we will learn in this video
How to Create SSIS Package from Scratch
How to create variables/Parameters in SSIS Package
How to use variables/Parameters in FTP Connection Manager Expressions and in FTP Task



How to use Variable/Parameters in FTP Connection Managers for Password,UserName and FTP Server Address



Related Posts / Videos on FTP Task / Script Task

1 comment:

  1. Welcome To Techbrothersit: How To Make Your Ftp Connection Manager Dynamic In Ssis Package - Sql Server Integration Services(Ssis) Tutorial >>>>> Download Now

    >>>>> Download Full

    Welcome To Techbrothersit: How To Make Your Ftp Connection Manager Dynamic In Ssis Package - Sql Server Integration Services(Ssis) Tutorial >>>>> Download LINK

    >>>>> Download Now

    Welcome To Techbrothersit: How To Make Your Ftp Connection Manager Dynamic In Ssis Package - Sql Server Integration Services(Ssis) Tutorial >>>>> Download Full

    >>>>> Download LINK h1

    ReplyDelete