No announcements
Found 466385 threads
-
0 VotesSort transformation drops rows?
??? My question was "Sort transformation drops rows?" and in so many words: WHY?Proposed | 6 Replies | 1000 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 | 1465 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 | 3553 Views | Created by Sqlstar07 - Monday, July 26, 2010 5:33 PM | Last reply by Manish Sharma - ETL - 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 | 3840 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 | 2215 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 | 5889 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 | 6150 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 | 782 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 | 2457 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 | 1723 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 | 4490 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 | 9019 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 | 3605 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 | 4645 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 | 2101 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 | 724 Views | Created by Rojit - Friday, August 5, 2016 2:35 PM | Last reply by ArthurZ - Sunday, August 7, 2016 3:59 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 | 8595 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
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 | 3374 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
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 | 5844 Views | Created by minority80 - Wednesday, March 7, 2007 2:05 AM | Last reply by minority80 - Friday, March 9, 2007 6:01 AM -
1 Votes
Out-of-Memory error on Sort Transformation
Was this really fixed in 2005 September CTP? I recently created a package in SSIS 2005 that does multiple sorts with in a data flow. It uses peak memory of ...Answered | 10 Replies | 10945 Views | Created by Raul Villaronga - Wednesday, June 22, 2005 2:11 PM | Last reply by Sarat C Reddy - Wednesday, October 12, 2011 6:37 PM - Items 1 to 20 of 466385 Next ›
No announcements
