No announcements
Found 2461428 threads
-
0 VotesNeed to lookup an Oracle Sequence value within a dataflow
I really need to be able to call the Oracle sequence in the data flow and receive the next available value whatever that might be because it could be out of order.Answered | 15 Replies | 12040 Views | Created by J.A.J. _ - Wednesday, April 18, 2007 12:31 AM | Last reply by J.A.J. _ - Friday, April 20, 2007 11:07 PM
-
0 Votes
Dataflow Sequencing
No. there is no notion of a sequence container in a dataflow.Answered | 8 Replies | 4259 Views | Created by Dick Campbell - Friday, October 8, 2010 8:21 AM | Last reply by Jamie Thomson - Friday, October 8, 2010 9:50 AM -
0 Votes
Oracle Sequence Number within SSIS
In the scriptask I use a ADO.NET Connection to my Oracle database.Answered | 3 Replies | 3733 Views | Created by Brendan L. Wood - Wednesday, July 22, 2015 3:38 PM | Last reply by tommeval - Monday, May 9, 2016 9:06 AM -
2 Votes
Stopping dataflow sequence
I have 3 connected dataflow blocks: TransformBlock b1, b2; ActionBlock b3 b1.LinkTo(b2); ...Answered | 1 Replies | 4335 Views | Created by Eugene Ivanchenko - Monday, April 16, 2012 7:06 AM | Last reply by svick - Monday, April 16, 2012 1:50 PM -
2 Votes
lookup oracle server error
When a row comes in from the input, the lookup component will compare the col_key column from the input against the col_key column in your reference dataset (in order to ...Answered | 8 Replies | 2564 Views | Created by sql.anandan - Monday, February 27, 2012 9:46 AM | Last reply by sql.anandan - Monday, February 27, 2012 1:28 PM -
0 Votes
SSIS dataflow, does is make a difference the order of the lookups
(The only impact where the data comes from in fully-cached lookups is the length of time spent in the PreExecute phase as it loads the in-memory Lookup cache from ...Answered | 1 Replies | 2005 Views | Created by GV1973 - Thursday, January 19, 2012 3:34 PM | Last reply by Todd McDermid - Thursday, January 19, 2012 4:49 PM -
0 Votes
Cannot map the input column (SQL Server) to the lookup column (Oracle)
I needed to use a Lookup Transformation instead of a Fuzzy Lookup because I need to use a query and not a table for the lookup source.Answered | 9 Replies | 3210 Views | Created by Retired_Fred - Tuesday, February 7, 2017 3:54 PM | Last reply by Retired_Fred - Monday, February 13, 2017 10:03 PM -
0 Votes
Need a DAX expression to find the closest value to lookup.
Hi Michael, According to your description, you nee a DAX expression to return the closest value from another table by given a value, right?Answered | 2 Replies | 2853 Views | Created by Michael Panciroli - Monday, April 25, 2016 2:34 AM | Last reply by Charlie Liao - Tuesday, April 26, 2016 5:52 AM -
0 Votes
SSIS Lookup Slow Performance
If you are using the stock Oracle OLEDB provider it will be slow as it works on a record by record basis.Answered | 1 Replies | 2664 Views | Created by Prajesh - Wednesday, August 14, 2013 1:34 PM | Last reply by ArthurZ - Wednesday, August 14, 2013 2:22 PM -
0 Votes
Can't get lookup data passed to Oracle Database
When I want to work with this string as a date on an Oracle database, then I have to convert it with the TO-DATE function ...Answered | 6 Replies | 2919 Views | Created by jbazelmans - Monday, September 30, 2019 6:51 AM | Last reply by Vaibhav.Chaudhari - Tuesday, December 24, 2019 2:08 PM -
0 Votes
running dataflow in different timings
You can place each data flow in a sequence container.Answered | 6 Replies | 3592 Views | Created by Sengwa - Tuesday, June 2, 2009 8:44 PM | Last reply by Sudeep Raj - Wednesday, June 3, 2009 1:19 PM -
0 Votes
Lookup or script task - check for record exists before doing dataflow
I have a Dataflow task within a foreach loop.Answered | 1 Replies | 1019 Views | Created by shiftbit - Monday, October 21, 2013 9:08 PM | Last reply by B3nt3n - Monday, October 21, 2013 10:13 PM -
0 Votes
SSIS Lookup in Oracle data type mismatch
Hi SQLSearcher99, What are the types of SP_LOC_ID and SP_TILL_Date in Both Oracle source?Answered | 3 Replies | 1622 Views | Created by SQLSearcher99 - Monday, November 14, 2016 12:33 PM | Last reply by SQLSearcher99 - Tuesday, November 15, 2016 11:30 AM -
0 Votes
Lookup function in SSRS 2008 R2 not returning a match from an oracle dataset
In the Oracle query text, I was trying to format the already date-time parameters into an Oracle date with the TO_DATE function.Answered | 3 Replies | 4909 Views | Created by mal0r - Tuesday, July 5, 2011 8:26 AM | Last reply by mal0r - Thursday, July 7, 2011 6:58 AM -
1 Votes
Using pipeline expressions to provide dataflow parameter values
You will need to use a Data Flow parameter type of String in order to use the option of pipeline parameters.Answered | 4 Replies | 781 Views | Created by xhead - Wednesday, September 4, 2019 9:19 PM | Last reply by Mark Kromer - Friday, September 6, 2019 8:37 PM -
0 Votes
Call an Oracle Sequence in a Data Flow to add a Primary Key
Another option is to load the data into a staging table in Oracle and perform an insert into the destination table, leveraging the sequence generator.Answered | 2 Replies | 1858 Views | Created by DaveDBA00 - Tuesday, March 18, 2014 8:41 PM | Last reply by Jim Young (Level6 Productions) - Wednesday, March 19, 2014 8:11 PM -
2 Votes
Dataflow task
Hi Pete, Nitesh, I could use the same sp in the dataflow task, however, the stored procedure reads an xml file and executes a couple of functions and ...Answered | 10 Replies | 2006 Views | Created by Pete Newman - Friday, March 1, 2013 4:43 PM | Last reply by Harry Bal - Friday, March 1, 2013 6:47 PM -
0 Votes
Dataflow Task
Hi Please explain about Dataflow Task .. when we are going to use that DataFlow Task.. what's the advantages of that DataFlow Taks and what are ...Answered | 4 Replies | 4624 Views | Created by Rammohan Ammiti - Friday, April 30, 2010 4:40 AM | Last reply by Jamie Thomson - Friday, April 30, 2010 8:53 AM -
0 Votes
Dataflow task Dataviewer not displaying
SQL statements need to either be in a stored procedure or very simple, then reconstructed within SSIS using various tasks.Answered | 4 Replies | 1014 Views | Created by shiftbit - Monday, March 28, 2016 3:40 PM | Last reply by shiftbit - Monday, March 28, 2016 5:31 PM -
0 Votes
Link to Sharepoint within Oracle EBS
If that's the case, all you need to do is build a custom .NET assembly connector for Business Connectivity Services (BCS).Answered | 5 Replies | 5420 Views | Created by BRai - Wednesday, April 18, 2012 7:50 PM | Last reply by Margriet Bruggeman - Friday, April 20, 2012 8:39 AM - Items 1 to 20 of 2461428 Next ›
No announcements
