Click here to Skip to main content
Click here to Skip to main content

Dynamically Export Data to Flat File Using SSIS

, 19 Dec 2011
Rate this:
Please Sign up or sign in to vote.
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)

About the Author

Keshav Singh
Database Developer
India India
I am a Microsoft certified Technology Specialist in MS SQL Server 2008 and 2005.I have fair amount of experience and expertise in MS database development, administration and modeling and MS BI. Started my career in 2007 and primarily into MS databases, and later diversified into MS BI especially SSIS. I also have a little exposure in Oracle 10g while working on one of the migration projects. But MS SQL Server is my passion!
 
Firm believer in knowledge grows from sharing, I really like reading books, trying new features and sharing the little that I know. Unless we're willing to have a go, fail miserably, have another go, success won't happen. The best thing I have discovered about myself is the "never say die" attitude. The best comment I have ever received is when my manager at my first job said "when this guy works he throws away his watch".

Comments and Discussions

 
Questionok Pinmemberselvaaa_09619-Dec-11 19:18 
GeneralMy vote of 3 Pinmemberselvaaa_09619-Dec-11 18:47 
ok

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140709.1 | Last Updated 19 Dec 2011
Article Copyright 2011 by Keshav Singh
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid