SSIS Tutorial Part 51-Dynamically Change the SQL Command in OLE DB Command Transformation

We have multiple tables with same structure for customers for each region. We have this requirement to build an SSIS Package that will read the data from flat file and then load the data depending upon the name of file. After loading the data to specific table, it will also update the records in history table. History Table follow the same meta data and name has _Hist at the end. What you will learn by watching this video How to create SQL Server Tables by using Create Statement How to Insert Rows for testing purpose in SQL server Tables How to Create an SSIS Package from basics How to use For-each Loop to read Multiple Files from a Folder Path Variable How to use Data Flow Task to read Flat file Source And perform Data Conversion How to use Variable in OLE DB Destination to change the name of Destination table dynamically How to Change the update Query for OLE DB Command Transformation Depending upon File Name How to write Expressions on Data Flow Task as well on Flat File Connection Manager Blog post link for scripts used in this video http://sqlage.blogspot.com/2015/05/dynamically-change-sql-command-in-ole.html Check out our Full Step by Step SQL Server Integration Services(SSIS) Tutorial http://www.techbrothersit.com/2014/12/ssis-videos.html