sorry for the trouble. got that sorted out, i didnt create / save the Solution table. hence i couldnt see the execute button in my SSIS. now i have a different issue. i have multiple column where the data for one particular column has moved from the actual column to before column, could you please help me how to get that information back to the actual column this data is taken from XML and it came like that.
Line_HTML - it should not have the data basically Line_Text - it should contain data
30% of my data is there in line_html column which it should not be
Hi, i am currently trying to sort the data using Sort Transformation for a database which has 23,00,000 ( 23 Lacs) data point. below mentioned are the steps i have done so far.
Create a DFT OLE Database Source - Selected the particular Database Sort Transformation - Session_ID Data type : (Numeric)& Line_Time data type : (Datetime) OLE Database Destination - Created a new table
also i tried to used the show advance editor and ISSORTED as True Session_ID 1 Line_time 2
but that is not sorting properly hence have choosed the sort transformation option.
currently Source table is completed and showing in GREEN Sort Transformation is in YELLOW Destination table is still in WHITE
nothing has moved so far
Missed to say one thing
Right clicked on the DFT clicked on Properties Default buffer Max Row as 10000 records Default buffer size changed to 104857600