SSIS Importing Data from Sql Server TO Multiple Flat Files

  • I had a table in sql server 2005 which contain 2 years of data i have to insert data in to 24 flat files with respect to months and i should get the information mail stating that the amount of data present in each flat file...

    Thanks in Advance.

    NaveenPrasad.Y

  • Did you need 24 different flat files?

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • Ya I need 24 different files .as per month wise data like january data should be inserted in to one file and the second month in to other file......

    NaveenPrasad.Y

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply