Dynamically Export Data to Flat File Using SSIS

While this video does not appear under "Videos" in the profile tab, it is part of videos on The Code Project. If you are interested in hosting a video on a coding solution on Code Project, email us at submit [at] codeproject.com.

With This SSIS

1. you will learn BCP
2. xp_cmdshell
3. Dynamic export of data from all the tables from a particular DB into a defined path out put. The output path can be dynamically configured.
4. A simple way to understand FOREACH container and how to pass result sets.
5. Also you will learn how to pass variable to execute SQL task.