SSIS Tutorial Part 29-How to Create Multiple Files from a SQL Server Table in SSIS Package

In this video you will learn how to create multiple files from a sql server table in SSIS Package.

Let's say you have a table with some region code information and you want to create files for each of the region with region code name , this example can be use to do that.

In this video you will also learn
How to create an SSIS Package
How to use OLE DB Source with parameters in ssis package
how to use Execute SQL Task to populate object type variable in ssis package
how to save data to object type variable in ssis package
how to read rows one by one from object type variable by using foreach loop container
how to create text files dynamically in ssis package
how to write expression on connection manager in ssis package
how to use data flow task in ssis package
how to use Foreach loop container in ssis package


To Follow Step by Step this SSIS video tutorial By Tech Brothers
http://www.techbrothersit.com/2014/12...