Workflow question
-
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.
-
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]
-
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!
-
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