Post reply

Data flow task

  • September 5, 2008 at 9:57 am

    #197815

    Hi all,

    A project that has a EXECUTION task that create a table called "dbo.MyNewtable"

    After that runs it calls a dataflow object which contains the following.

    1 - Source database(which is table in a db on server x)

    2 - Destination databse(which I want to set sa "dbo.MyNewtable" which still hasn't been created)

    How do set the the destination to my table?

    thanks

    Chris

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

  • September 5, 2008 at 11:43 am

    #867960

    I would just create the table for developemnt and create all the mappings. Your 1st step should then drop and recreate the table while executing.

    HTH

    Mukti

  • September 5, 2008 at 12:02 pm

    #867976

    If you have created the table for development, why drop and recreate it everytime? I'd change the create to truncate the existing table.

    😎

  • September 8, 2008 at 2:17 am

    #868322

    Do I need to the create in the OLEDB DAtasource object as well as the EXEXUTION TASK, which is before the Dataflow?

    Thanks

    Chris

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

  • September 8, 2008 at 11:11 am

    #868613

    Yes create the Execute SQL task before your Data flow that will truncate the table.

Viewing 5 posts - 1 through 4 (of 4 total)

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