Friday, April 13, 2012 4:53 PM
I am using the unpivot query in the oledb source in data flow task 1 in SSIS. Database is Oracle
source unpivot include nulls
(val for (source) in
(C1 as 'C1',
C2 as 'C2',
C3 as 'C3'))
I want to use the result of above query in the data flow task 2. How can i create a table (which will the resultset of the above query) on a fly so that i can continue with the outcome of that table created on fly.
Friday, April 13, 2012 8:23 PM
It is the continuation of my question.....
Should i create temp table??
create global temporary table tester as (
ext_npi_provider unpivot include nulls
(description for (address) in
(col21 as 'Business',
col22 as 'Business',
col29 as 'Practice',
col30 as 'Practice'
Will this approach work?
Friday, April 13, 2012 9:19 PMModerator
You can route any rowset from a Data Flow into a RAW File Destination that you can use in other Data Flow Tasks via the RAW File Source.
Or you can simply use the exact same query as the source for flow #2.
Or you can place the logic for flow #2 inside flow #1, and use a Multicast component to feed it from the same source.
Talk to me now on
Friday, April 13, 2012 9:26 PM
Todd, Talking about your second suggestion, how can i address the extract of dft 1 in dft 2. do i have to alias the extract in dft 1
Saturday, April 14, 2012 7:30 AMModerator
Tuesday, April 17, 2012 6:04 PM
Todd, how can i use the unpivot table from dft1 into dft2
Tuesday, April 17, 2012 6:45 PM
Actually, i want to use merge statement where i can update and insert into another table 2.
But first i have to unpivot the source table 1 before i can use it to merge records in table 2.
Please suggest the solution.
Wednesday, April 18, 2012 8:50 PMModerator
If you read from a source, manupulate the records, then want to use that changed rowset for two different purposes, you can do that two ways:
1. Use a Multicast component to make two copies of the rowset (in one DataFlow) and operate independently on the two (identical) rowsets.
2. Route the rowset to a RAW file using the RAW File Destination. In subsequent Data Flows, use the RAW File Source to read that rowset and operate on it.
Talk to me now on