avoid columns data "" in ssis package

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » avoid columns data "" in ssis package

avoid columns data "" in ssis package

Rate Topic

Display Mode

Topic Options

Author

Message

asranantha

Posted Thursday, February 21, 2013 1:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:31 AM
Points: 162, Visits: 3,821

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

sumit.joshij

Posted Thursday, February 21, 2013 1:32 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:06 AM
Points: 47, Visits: 266

Use "text qualifier" in File Connection Manager as " (doubleQuotes).
Smile

Post #1422427

sumit.joshij

Posted Thursday, February 21, 2013 1:43 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:06 AM
Points: 47, Visits: 266

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 »

Permissions