Post reply

Transform Sequence

  • June 17, 2003 at 8:43 am

    #106576

    Hi all.

    How canI change the sequence of mappings made in a transform task ?

    Problem example:

    Mapping 7 must now be executed after mapping 4 , mapping 6 after (7) and mapping 8 must now be done before any mapping takes place to set up DTSGlobalVariables. Mapping 7 must use GlobalVariables to do a lookup and provide a result in another DTSGlobalVariable for mapping 6 to use.

    Thanks.

    Graham

  • June 19, 2003 at 2:15 pm

    #462274

    Sounds a bit complex.

    I'd just import the data you have straight into a staging table. Then run couple of stored procedures to update required fields in the staging table. Then insert the records into your final destination.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

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

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