September 5, 2014 at 2:50 am
i have small doubt while extract text file data into sql server table using ssis tool. Source data (text file)like:
id , name , address
1 , abc , chennai,tamilnadu
based on this source data i want load same data into sql server table table data output like table name:test id name address 1 abc chennai,tamilnadu
please let me know where done mi stick while processing this data. first configure this text file that time header row delimiter {CR}{LF}. column delimiter:, after that i configure that file into table test.then i ran package after that i got result like below
id name address
1 abc chennai
but i want load address columns chennai,tamilnadu
September 5, 2014 at 5:39 am
Since you have the comma as a delimiter and the address data contains a comma as well, you are bound for trouble.
SSIS will think a new column has started.
You either choose a decent delimiter (something like |$|) or you use text qualifiers.
id , name , address
1 , "abc" , "chennai,tamilnadu"
In that case, you also need to be sure that " never occurs in the data itself, or you have issues again.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply