Post reply

create a table from flat file

  • February 19, 2010 at 8:57 am

    #138938

    Hi,

    I would like to create a database table from scratch using a flat file.

    I create my flat file connection and db connection and control flows and dataflows.

    However when I add the OLE DB destination the dialogue window is requesting an output location. I can't save without a location and it is not created yet.

    Thanks

    Chris

  • February 19, 2010 at 9:30 am

    #1121943

    haggisns (2/19/2010)

    Hi,

    I would like to create a database table from scratch using a flat file.

    I create my flat file connection and db connection and control flows and dataflows.

    However when I add the OLE DB destination the dialogue window is requesting an output location. I can't save without a location and it is not created yet.

    Thanks

    Chris

    Hi Chris,

    Unfortunately this feature doesn't exist in the current SSIS framework. It has been requested long time ago. What you have to do for now is the following:

    1. Create the destination table temporary. You need this to be able to setup you OLE DB Destination component.

    2. Set OLEDB Destination component DelayValidation property to TRUE. This is needed to avoid errors if the OLEDB destination is missing.

    3. Use ExecuteSQL Task to create your destination table, before executing your data flow.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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