Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

avoid columns data "" in ssis package Expand / Collapse
Author
Message
Posted Thursday, February 21, 2013 1:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 10:39 PM
Points: 211, Visits: 4,541
hi friends i have small doubt in ssis package
source data come text file that file contain data like


id , name
1 , "ravi"
10 , "venky"
1000 , "dd"
14200 , "jai"


when ever weload this data into destnation that time data must be load like this way

id , name
1 , ravi
10 , venky
1000 , dd
14200 , jai



plese tell me how to solve this issuse
Post #1422423
Posted Thursday, February 21, 2013 1:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 11:49 AM
Points: 48, Visits: 269
Use "text qualifier" in File Connection Manager as " (doubleQuotes).

Post #1422427
Posted Thursday, February 21, 2013 1:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 11:49 AM
Points: 48, Visits: 269
Or in more complex scenario using the Derived column, you can use the given below expression:
REPLACE([Column 1],"\"","")


Thanks and Regards,
Sumit Joshi
Moblie:- 0-9650899699, Skype: sumit.joshij
Blog: http://msbi2012.blogspot.in/
Post #1422433
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse