Home Forums Data Warehousing Integration Services In SSIS package Need to Create new table Dynamically for each 1000 Records RE: In SSIS package Need to Create new table Dynamically for each 1000 Records

  • venkatesh.b 88975 (9/13/2012)


    Dear all,

    I had a requirement like, I have a flat file with 10,000 records, I need to load this file to the Sql server tables for each 1000 records I need to create new table.

    ex: for this file I need to create 10 table to load the 10,000 records.

    Please help me on this.

    Thank'q

    Please let us know how did you approach so far and problem faced by you in implementing that.

    However just want to know why SSIS only means you could have bulk import also.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂