Post reply

Export SQL Table(only one table) data to multiple csv worksheets using SSIS

  • November 18, 2010 at 12:01 am

    #243058

    Hi All,

    Warm Greetings!!!

    I'm new to SSIS, just 2weeks old, am facing very much trouble to export data from sql table to multiple csv worksheets(sheet1,sheet2,.....)

    In SQL table i've more than 65536 records (for eg., 70000 records), while exporting table to csv only 65536 records got exported in sheet 1 remaining 4464 records must come in sheet 2 but it wasn't available.

    I used DataFlowTask -> OLEDB Source & FlatFileDestination tools.

    Pls help me out to resolve this issue, am awaiting for the reply

  • November 18, 2010 at 1:07 am

    #1252302

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1022640-148-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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