SSIS Tutorial Part 130-How To Execute Stored Procedure In Script Task in SSIS Package

SSIS Video Tutorial Scenario:
We need to get folder name from FTP Sever Directory and Insert them in SQL Server Table.
Solution:
we will be using Script Task to perform this requirement. here are the things we will cover in this video
Create SQL Server Table and Stored Procedure to insert Folder Name
Create an SSIS Package from basics
Use Script Task with FTP connection and ADO NET Connection, Get List of Folders from FTP Server and then execute Stored Procedure in Script Task to insert folder Name into table.
Link to the blog post for this video with script if used
sqlage.blogspot...