Import Multiple Text or CSV files to SQL Server Table by using Script Task in SSIS Package-P172

SSIS Video Scenario:
How to Import Multiple Text or CSV files to SQL Server Table by using Script Task in SSIS Package

You are working as ETL Developer / SSIS Developer. You get single or multiple text/csv files in Source Folder on daily basis. You want to create an SSIS Package that should be able to load all the files to single Table and archive after loading to table.

You want to built this package with configuration so by only provide different configuration values, it should be able to handle below scenarios

1) If your file provider decided to provide .txt file, it should be able to take them and load them
2) if your file provide decided to provide .csv files , by changing configuration value , package should be able to load the files
3) Table Name can change any time, so you should be able to provide table name by using configuration
4) Source Folder Path and Archive Folder Path can change, so you should be able to handle through configuration
5) File delimiter can also change, let's say you are getting files with comma(,). The file provider can make decision moving forward, he will be provide files with pipe( | ) .

Link for script used in this video
http://www.techbrothersit.com/2016/03/how-to-import-multiple-text-or-csv.html

Check out our other videos on related topic on Dynamic CSV Source and Destination



How to Import Multiple Text or CSV files to SQL Server Table by using Script Task in SSIS Package
How to Load Text /CSV files with same or less columns than destination table by using Script Task in SSIS Package
How to load Data from Multiple Text / CSV Files to SQL Server Table with File Name by using Script Task in SSIS Package
How to Create Tables Dynamically from Flat Files and load Data in SSIS Package
How to load Flat files to SQL Server Tables according to the Name of Flat File in SSIS Package
How to Create Multiple Text/CSV Files Dynamically From a SQL Server Table depening upon Distinct Column Value in SSIS Package
How to Export large table to multiple text/csv files by row count in SSIS Package
How to Load all text/csv files to single Text/CSV File from a folder in SSIS Package
How to create Text / CSV File Dynamically from Table or View in SSIS Package
How to create Text / CSV File Dynamically from Stored Procedure Results in SSIS Package
How to export all the tables from a database to CSV files with datetime in SSIS Package



check out www.TechBrothersIT.com for free Technology Tutorials /Interview Questions
SQL Server Integration Services(SSIS) Tutorial
SQL Server Reporting Services (SSRS) Tutorial
SQL Server / TSQL Tutorial