In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to extract the file names from folder and sub folders and insert that into a SQL Server Table by using SSIS Package.
In this video we will also learn
In this video we will also learn
- How to create an SSIS Package
- How to use Foreach Loop Containers to read the files from folders in SSIS Package
- How to use Execute SQL Task in SSIS Package
- How to pass parameter to Execute SQL Task in SSIS Package
Extract file Names from Folders and save in SQL Server Table by using SSIS Package - SQL Server Integration Services ( SSIS ) Tutorial
Check out our other related posts/videos on Containers
- How to Read Files according to Extension and Load them to a SQL Server Table in SSIS Package
- How To Load Files to Different Tables according to the File Name in SSIS Package
- How to load multiple Excel files to SQL Server Table and then archive them by adding date time to them?
- How to Execute Multiple dot SQL files by using SSIS Package
- How to Archive files with Date-time after loading into SQL Server Table in SSIS Package
- How to Create Multiple Files from a SQL Server Table in SSIS Package
Hi team,
ReplyDeleteI exactly applied the same Procedure with my package but it is showing error msg to me like:-
[Execute SQL Task] Error: Executing the query "insert into dbo.FileInformation(FileName) values
(..." failed with the following error: "Invalid object name 'dbo.FileInformation'.". Possible failure
reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly,
or connection not established correctly.