Topic
  • 4 replies
  • Latest Post - ‏2012-09-27T03:21:29Z by sqwnb
sqwnb
sqwnb
11 Posts

Pinned topic SQL Warehousing - Creation of New table - Table Target Operator

‏2012-09-20T08:59:39Z |
Hi,

I dont have a table in my DB with the required structure. So I want a target table to be created by the 'Table Target' operator.

I tried right clicking on 'Table Target'>Create Suitable Table

But it throws an error saying 'No Columns available in the operator port, the table cannot be created'

In Table Target>Map, i tried mapping the columns but in vain.

Please help.
Thanks in advance
Updated on 2012-09-27T03:21:29Z at 2012-09-27T03:21:29Z by sqwnb
  • SystemAdmin
    SystemAdmin
    203 Posts

    Re: SQL Warehousing - Creation of New table - Table Target Operator

    ‏2012-09-20T09:06:00Z  
    Hi,

    Could you upload the flow you tried to perform "Create Suitable Table"?

    The corresponding file(s) for the flow should be available in <workspace>/<project>/data-flows.

    Thanks,
    Wei.
  • sqwnb
    sqwnb
    11 Posts

    Re: SQL Warehousing - Creation of New table - Table Target Operator

    ‏2012-09-20T09:25:08Z  
    Hi,

    Could you upload the flow you tried to perform "Create Suitable Table"?

    The corresponding file(s) for the flow should be available in <workspace>/<project>/data-flows.

    Thanks,
    Wei.
    Hi,
    Attached is the flow i created.
  • SystemAdmin
    SystemAdmin
    203 Posts

    Re: SQL Warehousing - Creation of New table - Table Target Operator

    ‏2012-09-20T09:35:57Z  
    • sqwnb
    • ‏2012-09-20T09:25:08Z
    Hi,
    Attached is the flow i created.
    Hi,

    Let me clarify your requirement first:

    1) Are you trying to create a new table based on the Sample File?

    2) or you just specify an existing table in Table Target operator, and want to create suitable table based on the target table?

    If it's case #1, you should directly perform "create suitable table" action on the File Source operator.

    If it's case #2, what did you do against the Table Target (EPM89UAT.Test.Test)?

    I assume you pick up a table using the ... button - i.e. pick the table definition in a Data Base Model.

    Thanks,
    Wei.
  • sqwnb
    sqwnb
    11 Posts

    Re: SQL Warehousing - Creation of New table - Table Target Operator

    ‏2012-09-27T03:21:29Z  
    This works!

    Thanks!!