Post reply

Workflow question

  • October 14, 2004 at 12:56 pm

    #526821

    What do you mean by

    "Try separating the selects into two separate transformations..."?

    Put

    SELECT RF_ID INTO #t1

    FROM RF_INDEX

    in transformation 1

    and

    SELECT * FROM #t1 INNER JOIN RF_INDEX

    ON #t1.RF_ID =RF_INDEX.RF_ID

    DROP TABLE #t1

    in transformation 2?

    But the problem is I can't even create transformation 1.

    Transformation Tab is empty. No Source.

  • October 14, 2004 at 1:01 pm

    #526824

    If you are on the same connection, don't forget about your handy-dandy derived tables:

    SELECT * FROM tblOne INNER JOIN

    (

    SELECT RF_ID

    FROM tblTwo

    )

    tblThree

    ON tblThree.RF_ID = tblOne .RF_ID

    [font="Courier New"]ZenDada[/font]

  • October 14, 2004 at 1:23 pm

    #526831

    Jules,

    No matter what TSQL we insert in source connection

    Transformation can not be created.

    Source in Transformation Tab is empty.

    This is the main problem!

  • October 14, 2004 at 1:34 pm

    #526833

    SELECT RF_ID INTO #t1

    FROM RF_INDEX

    is not a valid transformation statement, but select myID from myTable is - see the diff?  You cannot use an insert statement - that is what the transformation does.

    The select statement is your source.  It must be a valid statement on your source connection, that is, myTable must belong to myDatabase in myConnection.

    First of all, where are you getting these id's from anyway?  Maybe we should start back at the beginning?    I am not so sure we are headed in the right direction with this!

    [font="Courier New"]ZenDada[/font]

Viewing 4 posts - 16 through 18 (of 18 total)

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