Post reply

is it possible to create table on the fly while importing flat file? BIDS 2008.

  • November 6, 2018 at 5:22 pm

    #382264

    is it possible to create table on the fly while importing flat file? BIDS 2008.
    something like
    <select * into NewTable from 'textfile'> would be nice.

    Likes to play Chess

  • November 6, 2018 at 5:39 pm

    #2012639

    not with standard SSIS methods

    Depending on the file you can however use a C# script to parse the file and create the table yourself.
    With bulk insert (T-SQL) it is possible to create the table on the fly though.

  • November 6, 2018 at 5:48 pm

    #2012641

    frederico_fonseca - Tuesday, November 6, 2018 5:39 PM

    not with standard SSIS methods

    Depending on the file you can however use a C# script to parse the file and create the table yourself.
    With bulk insert (T-SQL) it is possible to create the table on the fly though.

    So an ExecuteSQL task with a bulk insert might do it.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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