SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Need help as i am new to SSIS
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

karmeeabi
Starting Member

India
18 Posts

Posted - 06/26/2013 :  12:02:32  Show Profile  Reply with Quote
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

kindly help

Regards,
Karthik Shankaran (KS)
+91-9940074724
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 06/26/2013 :  13:14:53  Show Profile  Reply with Quote
do a t-sql update statement on the final table.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

karmeeabi
Starting Member

India
18 Posts

Posted - 07/11/2013 :  09:44:28  Show Profile  Reply with Quote
HI Visakh,

badly Need your help .

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

from 15:54:12
till 18:39:00

need help to fix this . please help me.



Regards,
Karthik Shankaran (KS)
+91-9940074724
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 07/11/2013 :  11:23:31  Show Profile  Reply with Quote
Why do you need sort transform? why cant you bring data sorted itself from source using SQL command as option for OLEDB source and using statement as

SELECT .. ORDER BY requiredcolumns?
Then set the Issorted property and also SortKey property for the columns.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000