Рет қаралды 14,417
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...