Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / SSIS

Dynamically Export Data to Flat File Using SSIS

3.89/5 (2 votes)
19 Dec 2011CPOL 33.4K  
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.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)