Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    56

    Unanswered: General SSIS package to export any table into .csv

    Hi guys,

    I need to create an SSIS package that takes a table name as a parameter and exports out its data in a CSV file.

    The challenge is that if I use a data flow task and a flat file connection manager (for csv export), I have to specify the file/table structure. I will not know the table structure until the run time because it is input specific.

    Has anyone had a similar problem and implemented a solution?

    I was thinking along the lines of using C# in a script task, but could not come up with a full blown solution.

    Any advise is appreciated.

    Thanks!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Consider using the BCP command in a T-SQL step

    bcp Utility
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •