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.
ReplyDeleteIt does not help us to learn and practice what you are doing if you are not sharing the source files. Creating these on our own is time consuming and it many cases causes us issues to copy what you are doing and follow along