In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to load multiple files to SQL Server Table and then archive them to archive folder by adding date and time to them.
In this video you will learn following tasks/transformations
In this video you will learn following tasks/transformations
- How to create an SSIS Package
- How to use For-each Loop Container to read the files from folder in SSIS Package
- How to load multiple text files to SQL Server Table in SSIS Package
- How to use Data Flow Task in SSIS Package
- How to Flat File Source in SSIS Package to read text file
- How to use OLE DB Destination to load data to SQL Server Table in SSIS Package
- How to write expressions in SSIS Package
- How to use File System Task in SSIS Package
- How to rename and move file in SSIS Package
Archive Files with Datetime after Loading into SQL Server Table - 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 Extract file names from Folders and save in SQL Server Table by using SSIS Package
- How to Create Multiple Files from a SQL Server Table in SSIS Package
No comments:
Post a Comment