No announcements
-
0 Votes
Sort transformation drops rows?
??? My question was "Sort transformation drops rows?" and in so many words: WHY?Proposed | 6 Replies | 847 Views | Created by TBQ - Tuesday, May 21, 2019 9:22 PM | Last reply by Mona Lv - Tuesday, June 4, 2019 3:16 AM -
0 Votes
Still not possible to add a working ComboBox to a DataGrid?
Hi Yann, I did the following unsuccessfull trials: 1) Created a silverlight class with a custom control from a xaml; 2) Created a custom ...Answered | 5 Replies | 1446 Views | Created by LightBoom - Friday, December 21, 2012 10:33 AM | Last reply by Yann Duran - Saturday, December 22, 2012 12:12 PM -
0 Votes
sort transformation
Two things: FIRST: Are there no other errors in your Output page when you run this? The error message you pasted eludes to that possiblility. SECOND: Why have the ...Answered | 2 Replies | 3485 Views | Created by Sqlstar07 - Monday, July 26, 2010 5:33 PM | Last reply by ETL vs ELTL - Tuesday, July 27, 2010 7:11 AM -
0 Votes
sort transformation
You can set the sort information metadata through the advanced editor, but it does not affect the order of the rows returned by the provider. That is determined by your query. How ...Proposed | 7 Replies | 3750 Views | Created by lakshmi nair - Thursday, July 14, 2011 5:27 PM | Last reply by lakshmi nair - Thursday, July 14, 2011 10:55 PM -
3 Votes
Sort transformation
Yes Harry you are correct, there is an option to remove duplicates in the sort transformation, b ut you would not want to sort the data(a blockingAnswered | 4 Replies | 2149 Views | Created by Harry Jaj - Monday, February 13, 2012 10:28 PM | Last reply by Koen Verbeeck - Tuesday, February 14, 2012 6:13 AM -
0 Votes
Treeview, GridView, Treegridview or what?
starts life as one datatable joined to itself via a separate table holding child parent keys. It can, however. be transformed into a different dataset or ...Answered | 6 Replies | 5788 Views | Created by Andy ONeill - Friday, March 12, 2010 11:21 AM | Last reply by giorgio79 - Thursday, April 15, 2010 5:25 PM -
0 Votes
SQL 2005 DW comparison to SQL server 2000
downstream data flow components. The Union All, Merge, and Merge Join transformations, for combining data rows from multiple upstream data flow ...Answered | 4 Replies | 6041 Views | Created by CJira - Tuesday, August 29, 2006 2:50 AM | Last reply by CJira - Tuesday, September 5, 2006 4:07 AM -
0 Votes
Avoid Sort Transformations
After this there are some data conversions and some logics and finally a UNION ALL Transformations before moving to the sort Transformation and last SQL SQL ...Unanswered | 3 Replies | 638 Views | Created by Rakesh Dhar - Wednesday, February 3, 2016 12:52 PM | Last reply by Jim Young (Level6 Productions) - Wednesday, February 3, 2016 8:24 PM -
2 Votes
Missing Sort transformation
I was surprised today. I was working on a package and using sort tranformation. I use it every day. Suddenly today it was missing in the transformation list. I checked everywhere in ...Answered | 5 Replies | 2338 Views | Created by Harry Jaj - Friday, January 27, 2012 12:47 AM | Last reply by ArthurZ - Friday, January 27, 2012 5:33 PM -
0 Votes
Drag and Drop and Render Transform.
Hello, I have a problem in Scale Transformation. What I am doing is dragging and dropping canvas ...Unanswered | 1 Replies | 1687 Views | Created by PrakashD - Monday, December 7, 2009 10:17 AM | Last reply by Kunal Chowdhury - Tuesday, December 22, 2009 5:38 AM -
0 Votes
DataGridView, Drag/Drop, Sorting
DGV with sorting enabled. Before sorting, rows can be dragged and dropped successfully. Applying a single sort by clicking on a column header ...Unanswered | 3 Replies | 4434 Views | Created by JohnZonie - Thursday, December 30, 2010 1:21 PM | Last reply by JohnZonie - Sunday, January 9, 2011 12:06 PM -
0 Votes
Only transform unique rows
Sort -> OLE DB destConfigure Sort transform to "Remove rows with duplicate sort values".2. OLE DB source ->Unanswered | 3 Replies | 8938 Views | Created by Sune Hansen - Wednesday, October 19, 2005 7:19 PM | Last reply by Sune Hansen - Thursday, October 20, 2005 7:31 PM -
0 Votes
Removing Duplicates Using Sort Transform
I took your advice and used a Transform Script to generate row numbers, immediately after the file was loaded. I then use Sort ...Answered | 10 Replies | 3565 Views | Created by Dick Campbell - Tuesday, July 21, 2009 7:31 AM | Last reply by Todd McDermid - Wednesday, July 22, 2009 3:31 PM -
0 Votes
Filter rows with script transformation
I want to filter rows in script transformation. Since there is no isnumeric function in SSIS, i want to use script transformation to removeAnswered | 1 Replies | 4576 Views | Created by Saeed Ahmad - Monday, March 3, 2008 8:21 PM | Last reply by Saeed Ahmad - Monday, March 3, 2008 8:54 PM -
1 Votes
sort transformation in ssis
hi, i am loading csv file file into table. i am using script componant which generate sequence number for each row , like ...Answered | 2 Replies | 2043 Views | Created by baba k - Wednesday, May 23, 2012 5:53 AM | Last reply by Koen Verbeeck - Wednesday, May 23, 2012 6:17 AM -
0 Votes
Alternatives to Sort Transformation
Hi, I am running a package having 1 terabyte of data and in the package we are doing various transformations including sorts before merge join ...Answered | 5 Replies | 585 Views | Created by Rojit - Friday, August 5, 2016 2:35 PM | Last reply by ArthurZ - Sunday, August 7, 2016 3:59 PM -
0 Votes
Sort transformation filters out data???
I saw the picture. It was basically a screen shot of a set completed Data Flow tasks showing all green with X number of rows indicated in the pipeline going INTO the Sort ...Answered | 5 Replies | 3310 Views | Created by tautvis - Thursday, June 30, 2011 12:09 PM | Last reply by Todd C - Thursday, June 30, 2011 3:42 PM -
0 Votes
Row Sampling Transform
for testing in that I could have a series of runs and each one ramping up the row counts. The final one would be "ALL" but without something on the transform to say ...Unanswered | 1 Replies | 8563 Views | Created by Allan Mitchell - Friday, October 21, 2005 3:17 PM | Last reply by Jamie Thomson - Saturday, October 22, 2005 9:18 AM -
0 Votes
Question on Row Count Transformation
I think you might want to add the row number transformation between the SCD and its Insert destination. You shouldn't have the primary key involved in the SCD -- only the ...Answered | 13 Replies | 5754 Views | Created by minority80 - Wednesday, March 7, 2007 2:05 AM | Last reply by minority80 - Friday, March 9, 2007 6:01 AM -
0 Votes
Sort XML without XSLt transformation
I am trying to compare Performance of the application using XSLT Transformation and without using xsl like using manual looping techiniques to display records... My xml file is not ...Answered | 3 Replies | 5740 Views | Created by dmouser - Friday, April 20, 2007 8:59 PM | Last reply by Sergey Dubinets - MSFT - Sunday, April 22, 2007 4:23 PM - Items 1 to 20 of 464739 Next ›
No announcements